Temenos Lifecycle Management Suite - Origination Product Guide
Rules Management - System Rules
| Administrator Guide > Rules Management > Rules Management - System Rules |
Each installation of Temenos Infinity's Loan Origination and/or Account Origination module comes with a set of pre-defined system rules that ensure specific processes and calculations occur within the system. System Rules can not be edited or deleted. Institutions are, however, able to copy the rules so that they can be edited to meet their individual needs. Once the custom rule is authored, the system-defined rule can be disabled.
The following categories contain the available system-defined rules within the Rules Management application:
| Aggregate Name | Rule Entity Level and Name | Calculation |
|
Disposable Income Per Dependant Postloan |
Applicant Entity Disposable_Income_Per_Dependant_Postloan_Applicant |
If Applicant’s Dependent Count = 0 Then 0 Else (the Applicant's total of Adjusted Monthly Income where Income Type <> Previous or Additional income) - (Application Monthly Payment Amount + (the Applicant's total of Adjusted Monthly Payments * (Percentage Responsible/100) where Liabilities Is Expense is true)) / Applicant's Dependent Count) |
|
Application Entity Disposable_Income_Per_Dependant_Postloan_Application |
If the total of Dependent Count for all Applicants = 0 Then 0 Else (the Application's total of Adjusted Monthly Income where Income Type <> Previous or Additional income and IncludeInApplicationAggregates is true) - (Application Monthly Payment Amount + (the Application's total of Adjusted Monthly Payments where Liabilities Is Expense is true and IncludeInApplicationAggregates is true)) / the total Dependent Count for all Applicants) |
|
|
Disposable Income Per Dependant Preloan |
Applicant Entity Disposable_Income_Per_Dependant_Preloan_Applicant |
If Applicant’s Dependent Count = 0 Then 0 Else (the Applicant's total of Adjusted Monthly Income where Income Type <> Previous or Additional income) - (the Applicant's total of Adjusted Monthly Payments * (Percentage Responsible/100) where Liabilities Is Expense is true) / Applicant's Dependent Count) |
|
Application Entity Disposable_Income_Per_Dependant_Preloan_Application |
If the total of Dependent Count for all Applicants = 0 Then 0 Else (the Application's total of Adjusted Monthly Income where Income Type <> Previous or Additional income and IncludeInApplicationAggregates is true) - (the Application's total of Adjusted Monthly Payments where Liabilities Is Expense is true and IncludeInApplicationAggregates is true)) |
|
|
Disposable Income Postloan |
Applicant Entity Disposable_Income_Postloan_Applicant |
(the Applicant's total of Adjusted Monthly Income where Income Type <> Previous or Additional income) - (Application's Monthly Payment Amount + (the Applicant's total of Adjusted Monthly Payments * (Percentage Responsible/100) where Liabilities Is Expense is true)) / Applicant's Dependent Count) |
|
Application Entity Disposable_Income_Postloan_Application |
(the Application's total of Adjusted Monthly Income where Income Type <> Previous or Additional income and IncludeInApplicationAggregates is true) - (Application's Monthly Payment Amount + (the Application's total of Adjusted Monthly Payments where Liabilities Is Expense is true and IncludeInApplicationAggregates is true)) | |
|
Disposable Income Preloan |
Applicant Entity Disposable_Income_Preloan_Applicant |
(the Applicant's total of Adjusted Monthly Income where Income Type <> Previous or Additional income) - (the Applicant's total of Adjusted Monthly Payments * (Percentage Responsible/100) where Liabilities Is Expense is true) |
|
Application Entity Disposable_Income_Preloan_Application |
(the Application's total of Adjusted Monthly Income where Income Type <> Previous or Additional income and IncludeInApplicationAggregates is true) - (the Application's total of Adjusted Monthly Payments where Liabilities Is Expense is true and IncludeInApplicationAggregates is true)) | |
| Loan Payment to Income |
Applicant Entity Loan_Payment_To_Income_Applicant |
If The aggregate “Total Income” for the applicant is equal to 0 Then (Set the ratio “Loan Payment To Income” for the applicant to 0) Else (Set the aggregate “Loan Payment To Income” for the applicant to ((Application MonthlyPaymentAmount plus Application LoanRealEstate TotMnthlyPaymentAmt) divided by the aggregate “Total Income” for the applicant)
|
|
|
Application Entity Loan_Payment_To_Income_Application |
If The aggregate “Total Income” for the application is equal to 0 Then (Set the aggregate “Loan Payment To Income” for the application to 0) Else (Set the aggregate “Loan Payment To Income” for the application to ((MonthlyPaymentAmount plus LoanRealEstate TotMnthlyPaymentAmt) divided by the aggregate “Total Income” for the application) |
|
Net Worth Postloan |
Applicant Entity Net_Worth_Postloan_Applicant |
(the Applicant's total of Adjusted Balance in Assets) - (Application's Initial Loan Amount + (the Applicant's total of Adjusted Balance * (Percentage Responsible/100) where LiabilitiesTrade Closed Type = Not Closed)) |
|
Application Entity Net_Worth_Postloan_Application |
(the Application total of Adjusted Balance in Assets) - (Application Initial Loan Amount + (the Application total of Adjusted Balance where LiabilitiesTrade Closed Type = Not Closed)) | |
|
Net Worth Preloan |
Applicant Entity Net_Worth_Preloan_Applicant |
(the Applicant's total of Adjusted Balance in Assets) - (the Applicant's total of Adjusted Balance * (Percentage Responsible/100) where LiabilitiesTrade Closed Type = Not Closed)) |
|
Application Entity Net_Worth_Preloan_Application |
(the Application total of Adjusted Balance in Assets) - (the Application total of Adjusted Balance where LiabilitiesTrade Closed Type = Not Closed) | |
|
Number Collateral |
Application Entity Number_Collateral_Application |
(the number of Collaterals on the Application) |
|
Number Expenses |
Applicant Entity Number_Expenses_Applicant |
(the Applicant's number of Liabilities where IsExpense is true) |
|
Application Entity Number_Expenses_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and IsExpense is true) | |
|
Number Expenses Balloon |
Applicant Entity Number_Expenses_Balloon_Applicant |
(the Applicant's number of Liabilities where IsExpense is true and (Balloon Amount is not Null and <> 0)) |
|
Application Entity Number_Expenses_Balloon_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and IsExpense is true and (Balloon Amount is not Null and <> 0)) | |
|
Number Expenses Balloon FI |
Applicant Entity Number_Expenses_Balloon_FI_Applicant |
(the Applicant's number of Liabilities where IsExpense is true and IsFromHost is true and (Balloon Amount is not Null and <> 0)) |
|
Application Entity Number_Expenses_Balloon_FI_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and IsExpense is true and IsFromHost is true and (Balloon Amount is not Null and <> 0)) | |
|
Number Expenses FI |
Applicant Entity Number_Expenses_FI_Applicant |
(the Applicant's number of Liabilities where IsExpense is true and IsFromHost is true) |
|
Application Entity Number_Expenses_FI_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and IsExpense is true and IsFromHost is true) | |
|
Number Expenses Installment |
Applicant Entity Number_Expenses_Installment_Applicant |
(the Applicant's number of Liabilities where IsExpense is true and (Account Type has a value of Installment, Mortgage, or Open/30 Day)) |
|
Application Entity Number_Expenses_Installment_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and IsExpense is true and (Account Type has a value of Installment, Mortgage or Open/30 Day )) | |
|
Number Expenses Installment FI |
Applicant Entity Number_Expenses_Installment_FI_Applicant |
(the Applicant's number of Liabilities where IsExpense is true and IsFromHost is true and (Account Type has a value of Installment, Mortgage, or Open/30 Day)) |
|
Application Entity Number_Expenses_Installment_FI_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and IsExpense is true and IsFromHost is true and (Account Type has a value of Installment, Mortgage or Open/30 Day )) | |
|
Number Expenses Revolving |
Applicant Entity Number_Expenses_Revolving_Applicant |
(the Applicant's number of Liabilities where IsExpense is true and (Account Type has a value of Credit Line, or Revolving)) |
|
Application Entity Number_Expenses_Revolving_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and IsExpense is true and (Account Type has a value of Credit Line, or Revolving)) | |
|
Number Expenses Revolving FI |
Applicant Entity Number_Expenses_Revolving_FI_Applicant |
(the Applicant's number of Liabilities where IsExpense is true and IsFromHost is true and (Account Type has a value of Credit Line, or Revolving)) |
|
Application Entity Number_Expenses_Revolving_FI_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and IsExpense is true and IsFromHost is true and (Account Type has a value of Credit Line, or Revolving)) | |
|
Number Expenses Secured |
Applicant Entity Number_Expenses_Secured_Applicant |
(the Applicant's number of Liabilities where IsExpense is true and IsSecured is true) |
|
Application Entity Number_Expenses_Secured_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and IsExpense is true and IsSecured is true) | |
|
Number Expenses Secured FI |
Applicant Entity Number_Expenses_Secured_FI_Applicant |
(the Applicant's number of Liabilities where IsExpense is true IsFromHost is true and IsSecured is true) |
|
Application Entity Number_Expenses_Secured_FI_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and IsExpense is true IsFromHost is true and IsSecured is true) | |
|
Number Expenses Unsecured |
Applicant Entity Number_Expenses_Unsecured_Applicant |
(the Applicant's number of Liabilities where IsExpense is true and IsSecured is false) |
|
Application Entity Number_Expenses_Unsecured_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and IsExpense is true and IsSecured is false) | |
|
Number Expenses Unsecured FI |
Applicant Entity Number_Expenses_Unsecured_FI_Applicant |
(the Applicant's number of Liabilities where IsExpense is true IsFromHost is true and IsSecured is false) |
|
Application Entity Number_Expenses_Unsecured_FI_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and IsExpense is true IsFromHost is true and IsSecured is false) | |
|
Number Trades |
Applicant Entity Number_Trades_Applicant |
(the Applicant's number of Liabilities) |
|
Application Entity Number_Trades_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true) | |
|
Number Trades Balloon |
Applicant Entity Number_Trades_Balloon_Applicant |
(the Applicant's number of Liabilities where (Balloon Amount is not Null and <> 0)) |
|
Application Entity Number_Trades_Balloon_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and (Balloon Amount is not Null and <> 0)) | |
|
Number Trades Balloon Closed |
Applicant Entity Number_Trades_Balloon_Closed_Applicant |
(the Applicant's number of Liabilities where (Balloon Amount is not Null and <> 0) and Trade Closed Type does not have a value of Not Closed) |
|
Application Entity Number_Trades_Balloon_Closed_Application |
(the Application's number of Liabilities where (Balloon Amount is not Null and <> 0) and IncludeInApplicationAggregates is true and TradeClosed Type does not have a value of Not Closed) | |
|
Number Trades Balloon Open |
Applicant Entity Number_Trades_Balloon_Open_Applicant |
(the Applicant's number of Liabilities where (Balloon Amount is not Null and <> 0) and Trade Closed Type has a value of Not Closed) |
|
Application Entity Number_Trades_Balloon_Open_Application |
(the Application's number of Liabilities where (Balloon Amount is not Null and <> 0) and IncludeInApplicationAggregates is true and TradeClosed Type has a value of Not Closed) | |
|
Number Trades Closed |
Applicant Entity Number_Trades_Closed_Applicant |
(the Applicant's number of Liabilities where Trade Closed Type does not have a value of Not Closed) |
|
Application Entity Number_Trades_Closed_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and TradeClosed Type does not have a value of Not Closed) | |
|
Number Trades Credit Cards |
Applicant Entity Number_Trades_Credit_Cards_Applicant |
(the Applicant's number of Liabilities where (Trade Category has a value of Credit Card, Department Store, or Miscellaneous Retail)) |
|
Application Entity Number_Trades_Credit_Cards_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and (Trade Category has a value of Credit Card, Department Store, or Miscellaneous Retail)) | |
|
Number Trades Credit Cards Closed |
Applicant Entity Number_Trades_Credit_Cards_Closed_Applicant |
(the Applicant's number of Liabilities where (Trade Category has a value of Credit Card, Department Store, or Miscellaneous Retail) and Trade Closed Type does not have a value of Not Closed) |
|
Application Entity Number_Trades_Credit_Cards_Closed_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and Trade Closed Type does not have a value of Not Closed and (Trade Category has a value of Credit Card, Department Store, or Miscellaneous Retail)) | |
|
Number Trades Credit Cards Open |
Applicant Entity Number_Trades_Credit_Cards_Open_Applicant |
(the Applicant's number of Liabilities where (Trade Category has a value of Credit Card, Department Store, or Miscellaneous Retail) and Trade Closed Type has a value of Not Closed) |
|
Application Entity Number_Trades_Credit_Cards_Open_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and Trade Closed Type has a value of Not Closed and (Trade Category has a value of Credit Card, Department Store, or Miscellaneous Retail)) | |
|
Number Trades Education Open |
Applicant Entity Number_Trades_Education_Open_Applicant |
(the Applicant's number of Liabilities where (Trade Category has a value of Education (Student Loans)) and Trade Closed Type has a value of Not Closed) |
|
Application Entity Number_Trades_Education_Open_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and Trade Closed Type has a value of Not Closed and (Trade Category has a value of Education (Student Loans))) | |
|
Number Trades Installment |
Applicant Entity Number_Trades_Installment_Applicant |
(the Applicant's number of Liabilities where (Account Type has a value of Installment, Mortgage, or Open/30 Day)) |
|
Application Entity Number_Trades_Installment_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and (Account Type has a value of Installment, Mortgage, or Open/30 Day)) | |
|
Number Trades Installment Closed |
Applicant Entity Number_Trades_Installment_Closed_Applicant |
(the Applicant's number of Liabilities where (Account Type has a value of Installment, Mortgage, or Open/30 Day) and Trade Closed Type does not have a value of Not Closed) |
|
Application Entity Number_Trades_Installment_Closed_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and (Account Type has a value of Installment, Mortgage, or Open/30 Day) and TradeClosedType does not have a value of Not Closed) | |
|
Number Trades Installment Open |
Applicant Entity Number_Trades_Installment_Open_Applicant |
(the Applicant's number of Liabilities where (Account Type has a value of Installment, Mortgage, or Open/30 Day) and Trade Closed Type has a value of Not Closed) |
|
Application Entity Number_Trades_Installment_Open_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and (Account Type has a value of Installment, Mortgage, or Open/30 Day) and TradeClosedType has a value of Not Closed) | |
|
Number Trades Medical Open |
Applicant Entity Number_Trades_Medical_Open_Applicant |
(the Applicant's number of Liabilities where Trade Category has a value of Medical and Trade Closed Type has a value of Not Closed) |
|
Application Entity Number_Trades_Medical_Open_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and TradeClosedType has a value of Not Closed and Trade Category has a value of Medical) | |
|
Number Trades Open |
Applicant Entity Number_Trades_Open_Applicant |
(the Applicant's number of Liabilities where Trade Closed Type has a value of Not Closed) |
|
Application Entity Number_Trades_Open_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and TradeClosedType has a value of Not Closed) | |
|
Number Trades Real Estate |
Applicant Entity Number_Trades_Real_Estate_Applicant |
(the Applicant's number of Liabilities where Trade Category has a value of Real Estate) |
|
Application Entity Number_Trades_Real_Estate_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and Trade Category has a value of Real Estate) | |
|
Number Trades Real Estate Closed |
Applicant Entity Number_Trades_Real_Estate_Closed_Applicant |
(the Applicant's number of Liabilities where Trade Category has a value of Real Estate and Trade Closed Type does not have a value of Not Closed) |
|
Application Entity Number_Trades_Real_Estate_Closed_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and Trade Closed Type does not have a values of Not Closed and Trade Category has a value of Real Estate) | |
|
Number Trades Real Estate Open |
Applicant Entity Number_Trades_Real_Estate_Open_Applicant |
(the Applicant's number of Liabilities where Trade Category has a value of Real Estate and Trade Closed Type has a value of Not Closed) |
|
Application Entity Number_Trades_Real_Estate_Open_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and Trade Closed Type has a values of Not Closed and Trade Category has a value of Real Estate) | |
|
Number Trades Revolving |
Applicant Entity Number_Trades_Revolving_Applicant |
(the Applicant's number of Liabilities where (Account Type has a value of Credit Line, or Revolving)) |
|
Application Entity Number_Trades_Revolving_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and (Account Type has a value of Credit Line, or Revolving)) | |
|
Number Trades Revolving Closed |
Applicant Entity Number_Trades_Revolving_Closed_Applicant |
(the Applicant's number of Liabilities where (Account Type has a value of Credit Line, or Revolving) and Trade Closed Type does not have a value of Not Closed) |
|
Application Entity Number_Trades_Revolving_Closed_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and (Account Type has a value of Credit Line, or Revolving) and Trade Closed Type does not have a values of Not Closed) | |
|
Number Trades Revolving Open |
Applicant Entity Number_Trades_Revolving_Open_Applicant |
(the Applicant's number of Liabilities where (Account Type has a value of Credit Line, or Revolving) and Trade Closed Type has a value of Not Closed) |
|
Application Entity Number_Trades_Revolving_Open_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and (Account Type has a value of Credit Line, or Revolving) and Trade Closed Type has a values of Not Closed) | |
|
Number Trades Secured |
Applicant Entity Number_Trades_Secured_Applicant |
(the Applicant's number of Liabilities where IsSecured is true) |
|
Application Entity Number_Trades_Secured_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and IsSecured is true) | |
|
Number Trades Secured Closed |
Applicant Entity Number_Trades_Secured_Closed_Applicant |
(the Applicant's number of Liabilities where IsSecured is true and TradeClosedType does not have a value of Not Closed) |
|
Application Entity Number_Trades_Secured_Closed_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and IsSecured is true and TradeClosedType does not have a value of Not Closed) | |
|
Number Trades Secured Open |
Applicant Entity Number_Trades_Secured_Open_Applicant |
(the Applicant's number of Liabilities where IsSecured is true and TradeClosedType has a value of Not Closed) |
|
Application Entity Number_Trades_Secured_Open_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and IsSecured is true and TradeClosedType has a value of Not Closed) | |
|
Number Trades Unsecured |
Applicant Entity Number_Trades_Unsecured_Applicant |
(the Applicant's number of Liabilities where IsSecured is false) |
|
Application Entity Number_Trades_Unsecured_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and IsSecured is false) | |
|
Number Trades Unsecured Closed |
Applicant Entity Number_Trades_Unsecured_Closed_Applicant |
(the Applicant's number of Liabilities where IsSecured is false and TradeClosedType does not have a value of Not Closed) |
|
Application Entity Number_Trades_Unsecured_Closed_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and IsSecured is false and TradeClosedType does not have a value of Not Closed) | |
|
Number Trades Unsecured Open |
Applicant Entity Number_Trades_Unsecured_Open_Applicant |
(the Applicant's number of Liabilities where IsSecured is false and TradeClosedType has a value of Not Closed) |
|
Application Entity Number_Trades_Unsecured_Open_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and IsSecured is false and TradeClosedType has a value of Not Closed) | |
|
Number Trades Vehicle |
Applicant Entity Number_Trades_Vehicle_Applicant |
(the Applicant's number of Liabilities where (Trade Category has a value of Automobile, Boat/Yacht, or Recreational Vehicle)) |
|
Application Entity Number_Trades_Vehicle_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and (Trade Category has a value of Automobile, Boat/Yacht, or Recreational Vehicle)) | |
|
Number Trades Vehicle Closed |
Applicant Entity Number_Trades_Vehicle_Closed_Applicant |
(the Applicant's number of Liabilities where (Trade Category has a value of Automobile, Boat/Yacht, or Recreational Vehicle) and Trade Closed Type does not have a value of Not Closed) |
|
Application Entity Number_Trades_Vehicle_Closed_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and (Trade Category has a value of Automobile, Boat/Yacht, or Recreational Vehicle) and Trade Closed Type does not have a value of Not Closed) | |
|
Number Trades Vehicle Open |
Applicant Entity Number_Trades_Vehicle_Open_Applicant |
(the Applicant's number of Liabilities where (Trade Category has a value of Automobile, Boat/Yacht, or Recreational Vehicle) and Trade Closed Type has a value of Not Closed) |
|
Application Entity Number_Trades_Vehicle_Open_Application |
(the Application's number of Liabilities where IncludeInApplicationAggregates is true and (Trade Category has a value of Automobile, Boat/Yacht,or Recreational Vehicle) and Trade Closed Type has a value of Not Closed) | |
|
Total Annual Income |
Applicant Entity Total_Annual_Income_Applicant |
(the Applicant's total of (Adjusted Monthly Income where Income Type does not have a value of Previous Income) *12) |
|
Application Entity Total_Annual_Income_Application |
(the Application's total of (Adjusted Monthly Income where Income Type does not have a value of Previous Income and IncludeInApplicationAggregates is true) *12) | |
|
Total Assets Available Balance |
Applicant Entity Total_Assets_Available_Balance_Applicant |
(the Applicant's total of Available Balance in Assets) |
|
Application Entity Total_Assets_Available_Balance_Application |
(the Application's total of Available Balance in Assets where IncludeInApplicationAggregates is true) | |
|
Total Assets Available Balance FI |
Applicant Entity Total_Assets_Available_Balance_FI_Applicant |
(the Applicant's total of Available Balance in Assets where IsFromHost is true) |
|
Application Entity Total_Assets_Available_Balance_FI_Application |
(the Application's total of Available Balance in Assets where IncludeInApplicationAggregates is true and IfFromHost is true) | |
|
Total Assets Available Balance Adj |
Applicant Entity Total_Assets_Available_Balance_Adj_Applicant |
(the Applicant's total of Adjusted Available Balance in Assets) |
|
Application Entity Total_Assets_Available_Balance_Adj_Application |
(the Application's total of Adjusted Available Balance in Assets where IncludeInApplicationAggregates is true) | |
|
Total Assets Available Balance Adj FI |
Applicant Entity Total_Assets_Available_Balance_Adj_FI_Applicant |
(the Applicant's total of Adjusted Available Balance in Assets where IsFromHost is true) |
|
Application Entity Total_Assets_Available_Balance_Adj_FI_Application |
(the Application's total of Adjusted Available Balance in Assets where IsFrom Host is true and IncludeInApplicationAggregates is true) | |
|
Total Assets Available Balance Adj FI Accounts |
Applicant Entity Total_Assets_Available_Balance_Adj_FI_Accounts_Applicant |
(the Applicant's total of Adjusted Available Balance in Assets where IsFromHost is true and (Asset Type has a value of Certificate, Checking, IRA, Money Market, or Saving)) |
|
Application Entity Total_Assets_Available_Balance_Adj_FI_Accounts_Application |
(the Application's total of Adjusted Available Balance in Assets where IsFrom Host is true and (Asset Type has a value of Certificate, Checking, IRA, Money Market, or Saving)and IncludeInApplicationAggregates is true) | |
|
Total Assets Available Balance Adj Life Insurance |
Applicant Entity Total_Assets_Available_Balance_Adj_Life_Insurance_Applicant |
(the Applicant's total of Adjusted Available Balance in Assets where Asset Type has a value of Life Insurance) |
|
Application Entity Total_Assets_Available_Balance_Adj_Life_Insurance_Application |
(the Application's total of Adjusted Available Balance in Assets where Asset Type has a value of Life Insurance and IncludeInApplicationAggregates is true) | |
|
Total Assets Available Balance Adj Other |
Applicant Entity Total_Assets_Available_Balance_Adj_Other_Applicant |
(the Applicant's total of Adjusted Available Balance in Assets where Asset Type has a value of Other) |
|
Application Entity Total_Assets_Available_Balance_Adj_Other_Application |
(the Application's total of Adjusted Available Balance in Assets where Asset Type has a value of Other and IncludeInApplicationAggregates is true) | |
|
Total Assets Available Balance Adj Other FI Accounts |
Applicant Entity Total_Assets_Available_Balance_Adj_Other_FI_Accounts_Applicant |
(the Applicant's total of Adjusted Available Balance in Assets where IsFromHost is false and (Asset Type has a value of Certificate, Checking, IRA, Money Market, or Saving)) |
|
Application Entity Total_Assets_Available_Balance_Adj_Other_FI_Accounts_Application |
(the Application's total of Adjusted Available Balance in Assets where IsFromHost is false and (Asset Type has a value of Certificate, Checking, IRA, Money Market, or Saving) and IncludeInApplicationAggregates is true) | |
|
Total Assets Available Balance Adj RE |
Applicant Entity Total_Assets_Available_Balance_Adj_Real_Estate_Applicant |
(the Applicant's total of Adjusted Available Balance in Assets where Asset Type has a value of Real Estate) |
|
Application Entity Total_Assets_Available_Balance_Adj_Real_Estate_Application |
(the Application's total of Adjusted Available Balance in Assets where Asset Type has a value of Other and IncludeInApplicationAggregates is true) | |
|
Total Assets Available Balance Adj Retirement |
Applicant Entity Total_Assets_Available_Balance_Adj_Retirement_Applicant |
(the Applicant's total of Adjusted Available Balance in Assets where Asset Type has a value of Retirement Accounts (401K, 403B, Pension)) |
|
Application Entity Total_Assets_Available_Balance_Adj_Retirement_Application |
(the Application's total of Adjusted Available Balance in Assets where Asset Type has a value of Retirement Accounts (401K, 403B, Pension) and IncludeInApplicationAggregates is true) | |
|
Total Assets Available Balance Adj Securities |
Applicant Entity Total_Assets_Available_Balance_Adj_Securities_Applicant |
(the Applicant's total of Adjusted Available Balance in Assets where Asset Type has a value of Securities (Stocks and Bonds)) |
|
Application Entity Total_Assets_Available_Balance_Adj_Securities_Application |
(the Application's total of Adjusted Available Balance in Assets where Asset Type has a value of Securities (Stocks and Bonds) and IncludeInApplicationAggregates is true) | |
|
Total Assets Available Balance Adj Vehicle |
Applicant Entity Total_Assets_Available_Balance_Adj_Vehicle_Applicant |
(the Applicant's total of Adjusted Available Balance in Assets where Asset Type has a value of Vehicle) |
|
Application Entity Total_Assets_Available_Balance_Adj_Vehicle_Application |
(the Application's total of Adjusted Available Balance in Assets where Asset Type has a value of Vehicle and IncludeInApplicationAggregates is true) | |
|
Total Assets Balance |
Applicant Entity Total_Assets_Balance_Applicant |
(the Applicant's total of Balance in Assets) |
|
Application Entity Total_Assets_Balance_Application |
(the Application's total of Balance in Assets where IncludeInApplicationAggregates is true) | |
|
Total Assets Balance FI |
Applicant Entity Total_Assets_Balance_FI_Applicant |
(the Applicant's total of Balance in Assets where IsFromHost is true) |
|
Application Entity Total_Assets_Balance_FI_Application |
(the Application's total of Balance in Assets where IsFromHost is true and IncludeInApplicationAggregates is true) | |
|
Total Assets Balance Adj |
Applicant Entity Total_Assets_Balance_Adj_Applicant |
(the Applicant's total of Adjusted Balance in Assets) |
|
Application Entity Total_Assets_Balance_Adj_Application |
(the Application's total of Adjusted Balance in Assets where IncludeInApplicationAggregates is true) | |
|
Total Assets Balance Adj FI |
Applicant Entity Total_Assets_Balance_Adj_FI_Applicant |
(the Applicant's total of Adjusted Balance in Assets where IsFromHost is true) |
|
Application Entity Total_Assets_Balance_Adj_FI_Application |
(the Application's total of Adjusted Balance in Assets where IsFromHost is true and IncludeInApplicationAggregates is true) | |
|
Total Assets Balance Adj FI Accounts |
Applicant Entity Total_Assets_Balance_Adj_FI_Accounts_Applicant |
(the Applicant's total of Adjusted Balance in Assets where IsFromHost is true and (Asset Type has a value of Certificate, Checking, IRA, Money Market, or Saving)) |
|
Application Entity Total_Assets_Balance_Adj_FI_Accounts_Application |
(the Application's total of Adjusted Balance in Assets where IsFromHost is true and (Asset Type has a value of Certificate, Checking, IRA, Money Market, or Saving) and IncludeInApplicationAggregates is true) | |
|
Total Assets Balance Adj Life Insurance |
Applicant Entity Total_Assets_Balance_Adj_Life_Insurance_Applicant |
(the Applicant's total of Adjusted Balance in Assets where Asset Type has a value of Life Insurance) |
|
Application Entity Total_Assets_Balance_Adj_Life_Insurance_Application |
(the Application's total of Adjusted Balance in Assets where Asset Type has a value of Life Insurance and IncludeInApplicationAggregates is true) | |
|
Total Assets Balance Adj Other |
Applicant Entity Total_Assets_Balance_Adj_Other_Applicant |
(the Applicant's total of Adjusted Balance in Assets where Asset Type has a value of Other) |
|
Application Entity Total_Assets_Balance_Adj_Other_Application |
(the Application's total of Adjusted Balance in Assets where Asset Type has a value of Other and IncludeInApplicationAggregates is true) | |
|
Total Assets Balance Adj Other FI Accounts |
Applicant Entity Total_Assets_Balance_Adj_Other_FI_Accounts_Applicant |
(the Applicant's total of Adjusted Balance in Assets where IsFromHost is false and (Asset Type has a value of Certificate, Checking, IRA, Money Market, or Saving)) |
|
Application Entity Total_Assets_Balance_Adj_Other_FI_Accounts_Application |
(the Application's total of Adjusted Balance in Assets where IsFromHost is false and (Asset Type has a value of Certificate, Checking, IRA, Money Market, or Saving) and IncludeInApplicationAggregates is true | |
|
Total Assets Balance Adj RE |
Applicant Entity Total_Assets_Balance_Adj_Real_Estate_Applicant |
(the Applicant's total of Adjusted Balance in Assets where Asset Type has a value of Real Estate) |
|
Application Entity Total_Assets_Balance_Adj_Real_Estate_Application |
(the Application's total of Adjusted Balance in Assets where Asset Type has a value of Real Estate and IncludeInApplicationAggregates is true) | |
|
Total Assets Balance Adj Retirement |
Applicant Entity Total_Assets_Balance_Adj_Retirement_Applicant |
(the Applicant's total of Adjusted Balance in Assets where Asset Type has a value of Retirement (401K, 403B, Pension)) |
|
Application Entity Total_Assets_Balance_Adj_Retirement_Application |
(the Application's total of Adjusted Balance in Assets where Asset Type has a value of Retirement (401K, 403B, Pension) and IncludeInApplicationAggregates is true) | |
|
Total Assets Balance Adj Securities |
Applicant Entity Total_Assets_Balance_Adj_Securities_Applicant |
(the Applicant's total of Adjusted Balance in Assets where Asset Type has a value of Securities (Stocks and Bonds)) |
|
Application Entity Total_Assets_Balance_Adj_Securities_Application |
(the Application's total of Adjusted Balance in Assets where Asset Type has a value of Securities (Stocks and Bonds) and IncludeInApplicationAggregates is true) | |
|
Total Assets Balance Adj Vehicle |
Applicant Entity Total_Assets_Balance_Adj_Vehicle_Applicant |
(the Applicant's total of Adjusted Balance in Assets where Asset Type has a value of Vehicle) |
|
Application Entity Total_Assets_Balance_Adj_Vehicle_Application |
(the Application's total of Adjusted Balance in Assets where Asset Type has a value of Vehicle and IncludeInApplicationAggregates is true) | |
|
Total Assets Hold Amount |
Applicant Entity Total_Assets_Hold_Amount_Applicant |
(the Applicant's total of Hold Amount in Assets) |
|
Application Entity Total_Assets_Hold_Amount_Application |
(the Application's total of Hold Amount in Assets where IncludeInApplicationAggregates is true) | |
|
Total Assets Hold Amount FI |
Applicant Entity Total_Assets_Hold_Amount_FI_Applicant |
(the Applicant's total of Hold Amount in Assets where IsFromHost is true) |
|
Application Entity Total_Assets_Hold_Amount_FI_Application |
(the Application's total of Hold Amount in Assets where IsFromHost is true and IncludeInApplicationAggregates is true) | |
|
Total Assets Market Value |
Applicant Entity Total_Assets_Market_Value_Applicant |
(the Applicant's total of Market Value in Assets) |
|
Application Entity Total_Assets_Market_Value_Application |
(the Application's total of Market Value in Assets where IncludeInApplicationAggregates is true) | |
|
Total Assets Market Value Life Insurance |
Applicant Entity Total_Assets_Market_Value_Life_Insurance_Applicant |
(the Applicant's total of Market Value in Assets where Asset Type has a value of Life Insurance) |
|
Application Entity Total_Assets_Market_Value_Life_Insurance_Application |
(the Application's total of Market Value in Assets where IncludeInApplicationAggregates is true and Asset Type has a value of Life Insurance) | |
|
Total Assets Market Value Other |
Applicant Entity Total_Assets_Market_Value_Other_Applicant |
the Applicant's total of Market Value in Assets where Asset Type has a value of Other) |
|
Application Entity Total_Assets_Market_Value_Other_Application |
(the Application's total of Market Value in Assets where IncludeInApplicationAggregates is true and Asset Type has a value of Other) | |
|
Total Assets Market Value RE |
Applicant Entity Total_Assets_Market_Value_Real_Estate_Applicant |
(the Applicant's total of Market Value in Assets where Asset Type has a value of Real Estate) |
|
Application Entity Total_Assets_Market_Value_Real_Estate_Application |
(the Application's total of Market Value in Assets where IncludeInApplicationAggregates is true and Asset Type has a value of Real Estate) | |
|
Total Assets Market Value Retirement |
Applicant Entity Total_Assets_Market_Value_Retirement_Applicant |
(the Applicant's total of Market Value in Assets where Asset Type has a value of Retirement (401K, 403B, Pension)) |
|
Application Entity Total_Assets_Market_Value_Retirement_Application |
(the Application's total of Market Value in Assets where IncludeInApplicationAggregates is true and Asset Type has a value of Securities (Stocks and Bonds)) | |
|
Total Assets Market Value Securities |
Applicant Entity Total_Assets_Market_Value_Securities_Applicant |
(the Applicant's total of Market Value in Assets where Asset Type has a value of Retirement (401K, 403B, Pension)) |
|
Application Entity Total_Assets_Market_Value_Securities_Application |
(the Application's total of Market Value in Assets where IncludeInApplicationAggregates is true and Asset Type has a value of Securities (Stocks and Bonds)) | |
|
Total Assets Market Value Vehicle |
Applicant Entity Total_Assets_Market_Value_Vehicle_Applicant |
(the Applicant's total of Market Value in Assets where Asset Type has a value of Vehicle) |
|
Application Entity Total_Assets_Market_Value_Vehicle_Application |
(the Application's total of Market Value in Assets where IncludeInApplicationAggregates is true and Asset Type has a value of Vehicle) | |
|
Total Assets Original Value |
Applicant Entity Total_Assets_Original_Value_Applicant |
(the Applicant's total of Original Value in Assets) |
|
Application Entity Total_Assets_Original_Value_Application |
(the Application's total of OriginalValue in Assets where IncludeInApplicationAggregates is true) | |
|
Total Collateral Additional Housing Expense |
Application Entity Total_Collateral_Additional_Housing_Expense_Applicationn |
(the Application's total of Down Payment in Collaterals) |
|
Total Collateral Down Payment |
Application Entity Total_Collateral_Down_Payment_Application |
(the Application's total of Down Payment in Collaterals) |
|
Total Collateral Liable Lien Amount |
Application Entity Total_Collateral_Liable_Lien_Amount_Applcation |
(the Application's total of Market Value in Collaterals) |
|
Total Collateral Lien Amount |
Application Entity Total_Collateral_Lien_Amount_Application |
(the Application's total of Market Value in Collaterals) |
|
Total Collateral Market Value |
Application Entity Total_Collateral_Market_Value_Application |
(the Application's total of Market Value in Collaterals) |
|
Total Collateral Market Value Adj |
Application Entity Total_Collateral_Market_Value_Adj_Application |
(the Application's total of Adjusted Market Value in Collaterals) |
|
Total Collateral Net Value |
Application Entity Total_Collateral_Net_Value_Application |
(the Application's total of Net Value in Collaterals) |
|
Total Collateral Net Value Adj |
Application Entity Total_Collateral_Net_Value_Adj_Application |
(the Application's total of Adjusted Net Value in Collaterals) |
|
Total Collateral Net Value Adj |
Application Entity Total_Collateral_Number_Shares_Application |
(the Application's total of Number Of Shares in Collaterals) |
|
Total Collateral Original Investment Value |
Application Entity Total_Collateral_Original_Investment_Value_Application |
(the Application's total of Original Investment Value in Collaterals) |
|
Total Collateral Original Value |
Application Entity Total_Collateral_Original_Value_Application |
(the Application's total of Original Value in Collaterals) |
|
Total Collateral Original Value Adj |
Application Entity Total_Collateral_Original_Value_Adj_Application |
(the Application's total of Adjusted Original Value in Collaterals) |
|
Total Collateral Purchase Price |
Application Entity Total_Collateral_Purchase_Price_Application |
(the Application's total of Purchase Price in Collaterals) |
|
Total Collateral Trade In Value |
Application Entity Total_Collateral_Trade_In_Value_Application |
(the Application's total of Value in Collaterals) |
|
Total Collateral Value |
Application Entity Total_Collateral_Value_Application |
(the Application's total of Collateral Value in Collaterals) |
|
Total Collateral Value Adj |
Application Entity Total_Collateral_Value_Adj_Application |
(the Application's total of Adjusted Value in Collaterals) |
|
Total Expenses Balance FI Postloan |
Applicant Entity Total_Expenses_Balance_FI_Postloan_Applicant |
(Application Initial Loan Amount + (the Applicant's total (Adjusted Balance * (Percentage Responsible / 100)) in Liabilities where IsExpense is true and IsFromHost is true) |
|
Application Entity Total_Expenses_Balance_FI_Postloan_Application |
(Application Initial Loan Amount + (the Application's total Adjusted Balance in Liabilities where IsExpense is true and IsFromHost is true and IncludeInApplicationAggregates is true) | |
|
Total Expenses Balance FI Preloan |
Applicant Entity Total_Expenses_Balance_FI_Preloan_Applicant |
(the Applicant's total (Adjusted Balance * (Percentage Responsible / 100) in Liabilities where IsExpense is true and IsFromHost is true)) |
|
Application Entity Total_Expenses_Balance_FI_Preloan_Application |
(the Application's total Adjusted Balance in Liabilities where IsExpense is true and IsFromHost is true and IncludeInApplicationAggregates is true) | |
|
Total Expenses Balance Installment FI Postloan |
Applicant Entity Total_Expenses_Balance_Installment_FI_Postloan_Applicant |
If the Application Loan Type has a value of Closed End Then (Application Initial Loan Amount + (the Applicant's total (Adjusted Balance * (Percentage Responsible / 100) in Liabilities where IsExpense is true and (Account Type has a values of Installment, Mortgage, or Open/30 Day) and IsFromHost is true)) Else (the Applicant's total (Adjusted Balance * (Percentage Responsible / 100) in Liabilities where IsExpense is true and (Account Type has a values of Installment, Mortgage, or Open/30 Day) and IsFromHost is true)) |
|
Application Entity Total_Expenses_Balance_Installment_FI_Postloan_Application |
If the Application Loan Type has a value of Closed End Then (Application Initial Loan Amount + (the Application's total Adjusted Balance in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and (Account Type has a values of Installment, Mortgage, or Open/30 Day) and IsFromHost is true)) Else (the Application's total Adjusted Balance in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and (Account Type has a values of Installment, Mortgage, or Open/30 Day) and IsFrom Host is true) |
|
|
Total Expenses Balance Installment FI Preloan |
Applicant Entity Total_Expenses_Balance_Installment_FI_Preloan_Applicant |
(the Applicant's total (Adjusted Balance * (Percentage Responsible / 100)) in Liabilities where IsExpense is true and (Account Type has a value of Installment, Mortgage, or Open/30 Day) and IsFromHost is true) |
|
Application Entity Total_Expenses_Balance_Installment_FI_Preloan_Application |
(the Application's total Adjusted Balance in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and (Account Type has a value of Installment, Mortgage, or Open/30 Day) and IsFromHost is true) | |
|
Total Expenses Balance Installment Postloan |
Applicant Entity Total_Expenses_Balance_Installment_Postloan_Applicant |
If the Application Loan Type has a value of Closed End Then (Application Initial Loan Amount + (the Applicant's total (Adjusted Balance * (Percentage Responsible / 100) in Liabilities where IsExpense is true and (Account Type has a values of Installment, Mortgage, or Open/30 Day))) Else (the Applicant's total (Adjusted Balance * (Percentage Responsible / 100) in Liabilities where IsExpense is true and (Account Type has a values of Installment, Mortgage, or Open/30 Day))) |
|
Application Entity Total_Expenses_Balance_Installment_Postloan_Application |
If the Application Loan Type has a value of Closed End Then (Application Initial Loan Amount + (the Application's total Adjusted Balance in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and (Account Type has a values of Installment, Mortgage, or Open/30 Day))) Else (the Application's total Adjusted Balance in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and (Account Type has a values of Installment, Mortgage, or Open/30 Day)) |
|
|
Total Expenses Balance Installment Preloan |
Applicant Entity Total_Expenses_Balance_Installment_Preloan_Applicant |
(the Applicant's total (Adjusted Balance * (Percentage Responsible / 100)) in Liabilities where IsExpense is true and (Account Type has a value of Installment, Mortgage, or Open/30 Day)) |
|
Application Entity Total_Expenses_Balance_Installment_Preloan_Application |
(the Application's total Adjusted Balance in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and (Account Type has a value of Installment, Mortgage, or Open/30 Day)) | |
|
Total Expenses Balance Postloan |
Applicant Entity Total_Expenses_Balance_Postloan_Applicant |
(the Applicant's total (Adjusted Balance * (Percentage Responsible / 100)) in Liabilities where IsExpense is true) + Application Initial Loan Amount |
|
Application Entity Total_Expenses_Balance_Postloan_Application |
(the Application's total os Adjusted Balance in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true) | |
|
Total Expenses Balance Preloan |
Applicant Entity Total_Expenses_Balance_Preloan_Applicant |
(the Applicant's total (Adjusted Balance * (Percentage Responsible / 100)) in Liabilities where IsExpense is true) + Application Initial Loan Amount |
|
Application Entity Total_Expenses_Balance_Preloan_Application |
(the Application's total os Adjusted Balance in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true) | |
|
Total Expenses Balance Revolving FI Postloan |
Applicant Entity Total_Expenses_Balance_Revolving_FI_Postloan_Applicant |
If the Application Loan Type has a value of Open End Then (Application Initial Loan Amount + (the Applicant's total (Adjusted Balance * (Percentage Responsible / 100) in Liabilities where IsExpense is true and (Account Type has a values of Credit Line, or Revolving) and IsFromHost is true)) Else (the Applicant's total (Adjusted Balance * (Percentage Responsible / 100) in Liabilities where IsExpense is true and (Account Type has a value of Credit Line, or Revolving) and IsFromHost is true)) |
|
Application Entity Total_Expenses_Balance_Revolving_FI_Postloan_Application |
If the Application Loan Type has a value of Open End Then (Application Initial Loan Amount + (the Application's total Adjusted Balance in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and (Account Type has a value of Credit Line, or Revolving) and IsFromHost is true)) Else (the Application's total Adjusted Balance in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and (Account Type has a values of Credit Line, or Revolving) and IsFromHost is true) |
|
|
Total Expenses Balance Revolving FI Preloan |
Applicant Entity Total_Expenses_Balance_Revolving_FI_Preloan_Applicant |
(the Applicant's total (Adjusted Balance * (Percentage Responsible / 100)) in Liabilities where IsExpense is true and (Account Type has a value of Credit Line, or Revolving) and IsFromHost is true) |
|
Application Entity Total_Expenses_Balance_Revolving_FI_Preloan_Application |
(the Application's total of Adjusted Balance in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and (Account Type has a value of Credit Line, or Revolving) and IsFromHost is true) | |
|
Total Expenses Balance Revolving Postloan |
Applicant Entity Total_Expenses_Balance_Revolving_Postloan_Applicant |
If the Application Loan Type has a value of Open End Then (Application Initial Loan Amount + (the Applicant's total (Adjusted Balance * (Percentage Responsible / 100) in Liabilities where IsExpense is true and (Account Type has a values of Credit Line, or Revolving))) Else (the Applicant's total (Adjusted Balance * (Percentage Responsible / 100) in Liabilities where IsExpense is true and (Account Type has a value of Credit Line, or Revolving))) |
|
Application Entity Total_Expenses_Balance_Revolving_Postloan_Application |
If the Application Loan Type has a value of Open End Then (Application Initial Loan Amount + (the Application's total Adjusted Balance in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and (Account Type has a value of Credit Line, or Revolving))) Else (the Application's total Adjusted Balance in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and (Account Type has a value of Credit Line, or Revolving)) |
|
|
Total Expenses Balance Revolving Preloan |
Applicant Entity Total_Expenses_Balance_Revolving_Preloan_Applicant |
(the Applicant's total (Adjusted Balance * (Percentage Responsible / 100)) in Liabilities where IsExpense is true and (Account Type has a value of Credit Line, or Revolving)) |
|
Application Entity Total_Expenses_Balance_Revolving_Preloan_Application |
(the Application's total of Adjusted Balance in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and (Account Type has a value of Credit Line, or Revolving)) | |
|
Total Expenses Balance Secured FI Postloan |
Applicant Entity Total_Expenses_Balance_Secured_FI_Postloan_Applicant |
If the Application IsSecured is true Then (Application Initial Loan Amount + (the Applicant's total Adjusted Balance * (Percentage Responsible / 100) in Liabilities where IsExpense is true and IsSecured is true and IsFromHost is true) Else (the Applicant's total Adjusted Balance * (Percentage Responsible / 100) in Liabilities where IsExpense is true and IsSecured is true and IsFromHost is true) |
|
Application Entity Total_Expenses_Balance_Secured_FI_Postloan_Application |
If IsSecured is true Then (Application Initial Loan Amount + (the Application's total Adjusted Balance in Liabilities where IncludeInApplicationAggregates is true and IsExpense is true and IsSecured is true and IsFromHost is true) Else (the Application's total Adjusted Balance in Liabilities where IncludeInApplicationAggregates is true and IsExpense is true and IsSecured is true and IsFromHost is true) |
|
|
Total Expenses Balance Secured FI Preloan |
Applicant Entity Total_Expenses_Balance_Secured_FI_Preloan_Applicant |
(the Applicant's total (Adjusted Balance * (Percentage Responsible / 100)) in Liabilities where IsExpense is true and IsSecured is true and IsFromHost is true) |
|
Application Entity Total_Expenses_Balance_Secured_FI_Preloan_Application |
(the Application's total (Adjusted Balance in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and IsSecured is true and IsFromHost is true) | |
|
Total Expenses Balance Secured Postloan |
Applicant Entity Total_Expenses_Balance_Secured_Postloan_Applicant |
If the Application IsSecured is true Then (Application Initial Loan Amount + (the Applicant's total Adjusted Balance * (Percentage Responsible / 100) in Liabilities where IsExpense is true and IsSecured is true) Else (the Applicant's total Adjusted Balance * (Percentage Responsible / 100) in Liabilities where IsExpense is true and IsSecured is true) |
|
Application Entity Total_Expenses_Balance_Secured_Postloan_Application |
If IsSecured is true Then (Application Initial Loan Amount + (the Application's total Adjusted Balance in Liabilities where IncludeInApplicationAggregates is true and IsExpense is true and IsSecured is true) Else (the Application's total Adjusted Balance in Liabilities where IncludeInApplicationAggregates is true and IsExpense is true and IsSecured is true) |
|
|
Total Expenses Balance Secured Preloan |
Applicant Entity Total_Expenses_Balance_Secured_Preloan_Applicant |
(the Applicant's total (Adjusted Balance * (Percentage Responsible / 100)) in Liabilities where IsExpense is true and IsSecured is true) |
|
Application Entity Total_Expenses_Balance_Secured_Preloan_Application |
(the Application's total (Adjusted Balance in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and IsSecured is true) | |
|
Total Expenses Balance Unsecured FI Postloan |
Applicant Entity Total_Expenses_Balance_Unsecured_FI_Postloan_Applicant |
If the Application IsSecured is false Then (Application Initial Loan Amount + (the Applicant's total Adjusted Balance * (Percentage Responsible / 100) in Liabilities where IsExpense is true and IsSecured is false and IsFromHost is true) Else (the Applicant's total Adjusted Balance * (Percentage Responsible / 100) in Liabilities where IsExpense is true and IsSecured is false and IsFromHost is true) |
|
Application Entity Total_Expenses_Balance_Unsecured_FI_Postloan_Application |
If IsSecured is false Then (Application Initial Loan Amount + (the Application's total Adjusted Balance in Liabilities where IncludeInApplicationAggregates is true and IsExpense is true and IsSecured is false and IsFromHost is true) Else (the Application's total Adjusted Balance in Liabilities where IncludeInApplicationAggregates is true and IsExpense is true and IsSecured is false and IsFromHost is true) |
|
|
Total Expenses Balance Unsecured FI Preloan |
Applicant Entity Total_Expenses_Balance_Unsecured_FI_Preloan_Applicant |
(the Applicant's total (Adjusted Balance * (Percentage Responsible / 100)) in Liabilities where IsExpense is true and IsSecured is false and IsFromHost is true) |
|
Application Entity Total_Expenses_Balance_Unsecured_FI_Preloan_Application |
(the Application's total (Adjusted Balance in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and IsSecured is false and IsFromHost is true) | |
|
Total Expenses Balance Unsecured Postloan |
Applicant Entity Total_Expenses_Balance_Unsecured_Postloan_Applicant |
If the Application IsSecured is false Then (Application Initial Loan Amount + (the Applicant's total Adjusted Balance * (Percentage Responsible / 100) in Liabilities where IsExpense is true and IsSecured is false) Else (the Applicant's total Adjusted Balance * (Percentage Responsible / 100) in Liabilities where IsExpense is true and IsSecured is false |
|
Application Entity Total_Expenses_Balance_Unsecured_Postloan_Application |
If IsSecured is false Then (Application Initial Loan Amount + (the Application's total Adjusted Balance in Liabilities where IncludeInApplicationAggregates is true and IsExpense is true and IsSecured is false) Else (the Application's total Adjusted Balance in Liabilities where IncludeInApplicationAggregates is true and IsExpense is true and IsSecured is false) |
|
|
Total Expenses Balance Unsecured Preloan |
Applicant Entity Total_Expenses_Balance_Unsecured_Preloan_Applicant |
(the Applicant's total (Adjusted Balance * (Percentage Responsible / 100)) in Liabilities where IsExpense is true and IsSecured is false) |
|
Application Entity Total_Expenses_Balance_Unsecured_Preloan_Application |
(the Application's total (Adjusted Balance in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and IsSecured is false) | |
|
Total Expenses Balloon FI Postloan |
Applicant Entity Total_Expenses_Balloon_FI_Postloan_Applicant |
(the Applicant's total (Balloon Amount * (Percentage Responsible / 100)) in Liabilities where IsFromHost is true and IsExpense is true) + Application Balloon Amount |
|
Application Entity Total_Expenses_Balloon_FI_Postloan_Application |
(the Application's total of Balloon Amount in Liabilities where IsExpense is true and IsFromHost is true and IncludeInApplicationAggregates is true) + Application Balloon Amount | |
|
Total Expenses Balloon FI Preloan |
Applicant Entity Total_Expenses_Balloon_FI_Preloan_Applicant |
(the Applicant's total (Balloon Amount * (Percentage Responsible / 100)) in Liabilities where IsFromHost is true and IsExpense is true) |
|
Application Entity Total_Expenses_Balloon_FI_Preloan_Application |
(the Application's total of Balloon Amount in Liabilities where IsExpense is true and IsFromHost is true and IncludeInApplicationAggregates is true) | |
|
Total Expense Balloon Postloan |
Applicant Entity Total_Expenses_Balloon_Postloan_Applicant |
(the Applicant's total (Balloon Amount * (Percentage Responsible / 100)) in Liabilities where IsExpense is true) + Application Balloon Amount |
|
Application Entity Total_Expenses_Balloon_Postloan_Application |
(the Application's total of Balloon Amount in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true) + Application Balloon Amount | |
|
Total Expenses Balloon Preloan |
Applicant Entity Total_Expenses_Balloon_Preloan_Applicant |
(the Applicant's total (Balloon Amount * (Percentage Responsible / 100)) in Liabilities where IsExpense is true) |
|
Application Entity Total_Expenses_Balloon_Preloan_Application |
(the Application's total of Balloon Amount in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true) | |
|
Total Expenses Limit Revolving FI Postloan |
Applicant Entity Total_Expenses_Limit_Revolving_FI_Postloan_Applicant |
If the Application Loan Type has a value of Open End Then (Application Initial Loan Amount + (the Applicant's total Adjusted Limit in Liabilities where IsExpense is true and (Account Type has a value of Credit Line, or Revolving) and IsFromHost is true) Else (the Applicant's total Adjusted Limit in Liabilities where IsExpense is true and (Account Type has a value of Credit Line, or Revolving) and IsFromHost is true) |
|
Application Entity Total_Expenses_Limit_Revolving_FI_Postloan_Application |
If the Application Loan Type has a value of Open End Then (Application Initial Loan Amount + (the Application's total Adjusted Limit n Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and (Account Type has a value of Credit Line, or Revolving) and IsFromHost is true) Else (the Application's total Adjusted Limit n Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and (Account Type has a value of Credit Line, or Revolving) and IsFromHost is true) |
|
|
Total Expenses Limit Revolving FI Preloan |
Applicant Entity Total_Expenses_Limit_Revolving_FI_Preloan_Applicant |
(the Applicant's total Adjusted Limit in Liabilities where IsExpense is true and (Account Type has a value of Credit Line, or Revolving) and IsFromHost is true) |
|
Application Entity Total_Expenses_Limit_Revolving_FI_Preloan_Application |
(the Application's total Adjusted Limit n Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and (Account Type has a value of Credit Line, or Revolving) and IsFromHost is true) | |
|
Total Expenses Limit Revolving Postloan |
Applicant Entity Total_Expenses_Limit_Revolving_Postloan_Applicant |
If the Application Loan Type has a value of Open End Then (Application Initial Loan Amount + (the Applicant's total Adjusted Limit in Liabilities where IsExpense is true and (Account Type has a value of Credit Line, or Revolving)) Else (the Applicant's total Adjusted Limit in Liabilities where IsExpense is true and (Account Type has a value of Credit Line, or Revolving)) |
|
Application Entity Total_Expenses_Limit_Revolving_Postloan_Application |
If the Application Loan Type has a value of Open End Then (Application Initial Loan Amount + (the Application's total Adjusted Limit n Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and (Account Type has a value of Credit Line, or Revolving)) Else (the Application's total Adjusted Limit n Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and (Account Type has a value of Credit Line, or Revolving)) |
|
|
Total Expenses Limit Revolving Preloan |
Applicant Entity Total_Expenses_Limit_Revolving_Preloan_Applicant |
(the Applicant's total Adjusted Limit in Liabilities where IsExpense is true and (Account Type has a value of Credit Line, or Revolving)) |
|
Application Entity Total_Expenses_Limit_Revolving_Preloan_Application |
(the Application's total Adjusted Limit n Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and (Account Type has a value of Credit Line, or Revolving)) | |
|
Total Expenses Limit Unsecured FI Postloan |
Applicant Entity Total_Expenses_Limit_Unsecured_FI_Postloan_Applicant |
If the Application IsSecured is false Then (Application Initial Loan Amount + (the Applicant's total Adjusted Limit * (Percentage Responsible / 100) in Liabilities where IsExpense is true and IsSecured is false and IsFromHost is true) Else (the Applicant's total Adjusted Limit * (Percentage Responsible / 100) in Liabilities where IsExpense is true and IsSecured is false and IsFromHost is true) |
|
Application Entity Total_Expenses_Limit_Unsecured_FI_Postloan_Application |
If IsSecured is false Then (Application Initial Loan Amount + (the Application's total Adjusted Limit in Liabilities where IncludeInApplicationAggregates is true and IsExpense is true and IsSecured is false and IsFromHost is true) Else (the Application's total Adjusted Limit in Liabilities where IncludeInApplicationAggregates is true and IsExpense is true and IsSecured is false and IsFromHost is true) |
|
|
Total Expenses Limit Unsecured FI Preloan |
Applicant Entity Total_Expenses_Limit_Unsecured_FI_Preloan_Applicant |
(the Applicant's total (Adjusted Limit * (Percentage Responsible / 100)) in Liabilities where IsExpense is true and IsSecured is false and IsFromHost is true) |
|
Application Entity Total_Expenses_Limit_Unsecured_FI_Preloan_Application |
(the Application's total (Adjusted Limit in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and IsSecured is false and IsFromHost is true) | |
|
Total Expenses Limit Unsecured Postloan |
Applicant Entity Total_Expenses_Limit_Unsecured_Postloan_Applicant |
If the Application IsSecured is false Then (Application Initial Loan Amount + (the Applicant's total Adjusted Limit * (Percentage Responsible / 100) in Liabilities where IsExpense is true and IsSecured is false) Else (the Applicant's total Adjusted Limit * (Percentage Responsible / 100) in Liabilities where IsExpense is true and IsSecured is false) |
|
Application Entity Total_Expenses_Limit_Unsecured_Postloan_Application |
If IsSecured is false Then (Application Initial Loan Amount + (the Application's total Adjusted Limit in Liabilities where IncludeInApplicationAggregates is true and IsExpense is true and IsSecured is false) Else (the Application's total Adjusted Limit in Liabilities where IncludeInApplicationAggregates is true and IsExpense is true and IsSecured is false) |
|
|
Total Expenses Limit Unsecured Preloan |
Applicant Entity Total_Expenses_Limit_Unsecured_Preloan_Applicant |
(the Applicant's total (Adjusted Limit * (Percentage Responsible / 100)) in Liabilities where IsExpense is true and IsSecured is false) |
|
Application Entity Total_Expenses_Limit_Unsecured_Preloan_Application |
(the Application's total (Adjusted Limit in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and IsSecured is false) | |
|
Total Expenses Payment Credit Cards Open |
Applicant Entity Total_Expenses_Payment_Credit_Cards_Open_Applicant |
(the Applicant's total (Adjusted Monthly Payment * (Percentage Responsible / 100) in Liabilities where IsExpense is true and Trade Closed Type has a value of Not Closed and (Trade Category has a value of Credit Card, Department Store, or Miscellaneous Retail)) |
|
Application Entity Total_Expenses_Payment_Credit_Cards_Open_Application |
(the Application's total of Adjusted Monthly Payment in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and (Trade Category has a value of Credit Card, Department Store, or Miscellaneous Retail) and Trade Closed Type has a value of Not Closed) | |
|
Total Expenses Payment Education Open |
Applicant Entity Total_Expenses_Payment_Education_Open_Applicant |
(the Applicant's total (Adjusted Monthly Payment * (Percentage Responsible / 100) in Liabilities where IsExpense is true and Trade Closed Type has a value of Not Closed and Trade Category has a value of Education (Student Loans))) |
|
Application Entity Total_Expenses_Payment_Education_Open_Application |
(the Application's total of Adjusted Monthly Payment in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and (Trade Category has a value of Education (Student Loans)) and Trade Closed Type has a value of Not Closed) | |
|
Total Expenses Payment FI Postloan |
Applicant Entity Total_Expenses_Payment_FI_Postloan_Applicant |
Set the aggregate “Total Expenses Payment FI Postloan” for the applicant to ((Application MonthlyPaymentAmount plus Application LoanRealEstate TotMthlyPaymentAmt) plus (the total of (AdjustedMonthlyPayment multiplied by (PercentageResponsible divided by 100)) in Liabilities filtered by IsExpense is true and IsFromHost is true)) |
|
Application Entity Total_Expenses_Payment_FI_Postloan_Application |
Set the aggregate “Total Expenses Payment FI Postloan” for the application to ((MonthlyPaymentAmount plus LoanRealEstate TotMthlyPaymentAmt) plus (the total of AdjustedMonthlyPayment in Liabilities filtered by IsExpense is true and IsFromHost is true and IncludeInApplicationAggregate is true)) | |
|
Total Expenses Payment FI Preloan |
Applicant Entity Total_Expenses_Payment_FI_Preloan_Applicant |
(the Applicant's total (Adjusted Monthly Payment * (Percentage Responsible / 100) in Liabilities where IsFromHost is true and IsExpense is true)) |
|
Application Entity Total_Expenses_Payment_FI_Preloan_Application |
(the Application's total of Adjusted Monthly Payment in Liabilities where IsExpense is true and IsFromHost is true and IncludeInApplicationAggregates is true | |
|
Total Expenses Payment Housing Postloan |
Applicant Entity Total_Expenses_Payment_Housing_Postloan_Applicant |
Take the following: (If Then (Set the aggregate “Total Expenses Payment Housing Postloan” for the applicant to ((Application MonthlyPaymentAmount plus Application LoanRealEstate TotMthlyPaymentAmt) plus (the total of (AdjustedMonthlyPayment multiplied by (PercentageResponsible divided by 100)) in Liabilities filtered by IsExpense is true and AccountType has a value of “Mortgage”)) ( Set the aggregate “Total Expenses Payment Housing Postloan” for the applicant to (the total of (AdjustedMonthlyPayment multiplied by (PercentageResponsible divided by 100)) in Liabilities filtered by IsExpense is true and AccountType has a value of “Mortgage”) |
|
Application Entity Total_Expenses_Payment_Housing_Postloan_Application |
If TradeType has a value of “Mortgage” Then (Set the aggregate “Total Expenses Payment Housing Postloan” for the application to ((MonthlyPaymentAmount plus LoanRealEstate TotMthlyPaymentAmt) plus (the total of AdjustedMonthlyPayment in Liabilities filtered by IsExpense is true and IncludeInApplicationAggregate is true and AccountType has a value of “Mortgage”)) Else (Set the aggregate “Total Expenses Payment Housing Postloan” for the application to (the total of AdjustedMonthlyPayment in Liabilities filtered by IsExpense is true and IncludeInApplicationAggregate is true and AccountType has a value of “Mortgage”) |
|
|
Total Expenses Payment Housing Preloan |
Applicant Entity Total_Expenses_Payment_Housing_Preloan_Applicant |
(the Applicant's total (Adjusted Monthly Payment * (Percentage Responsible / 100) in Liabilities where IsExpense is true and Account Type has a value of Mortgage)) |
|
Application Entity Total_Expenses_Payment_Housing_Preloan_Application |
(the Application's total Adjusted Monthly Payment in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and Account Type has a value of Mortgage ))) | |
|
Total Expenses Payment Installment FI Postloan |
Applicant Entity Total_Expenses_Payment_Installment_FI_Postloan_Applicant |
If Application LoanType has a value of “Closed End” Then (Set the aggregate “Total Expenses Payment Installment FI Postloan” for the applicant to ((Application MonthlyPaymentAmount plus Application LoanRealEstate TotMthlyPaymentAmt) plus (the total of (AdjustedMonthlyPayment multiplied by (PercentageResponsible divided by 100)) in Liabilities filtered by IsExpense is true and AccountType has a value of “Installment, Mortgage, Open/30 day” and IsFromHost is true)) Else (Set the aggregate “Total Expenses Payment Installment FI Postloan” for the applicant to (the total of (AdjustedMonthlyPayment multiplied by (PercentageResponsible divided by 100)) in Liabilities filtered by IsExpense is true and AccountType has a value of “Installment, Mortgage, Open/30 day” and IsFromHost is true) |
|
Application Entity Total_Expenses_Payment_Installment_FI_Postloan_Application |
If LoanType has a value of “Closed End”
Then (Set the aggregate “Total Expenses Payment Installment FI Postloan” for the application to ((MonthlyPaymentAmount plus LoanRealEstate TotMthlyPaymentAmt) plus (the total of AdjustedMonthlyPayment in Liabilities filtered by IsExpense is true and IncludeInApplicationAggregate is true and AccountType has a value of “Installment, Mortgage, Open/30 day” and IsFromHost is true)) Else (Set the aggregate “Total Expenses Payment Installment FI Postloan” for the application to (the total of AdjustedMonthlyPayment in Liabilities filtered by IsExpense is true and IncludeInApplicationAggregate is true and AccountType has a value of “Installment, Mortgage, Open/30 day” and IsFromHost is true) |
|
|
Total Expenses Payment Installment FI Preloan |
Applicant Entity Total_Expenses_Payment_Installment_FI_Preloan_Applicant |
(the Applicant's total (Adjusted Monthly Payment * (Percentage Responsible / 100) in Liabilities where IsExpense is true and (Account Type has a value of Installment, Mortgage, or Open/30 Day) and IsFromHost is true)) |
|
Application Entity Total_Expenses_Payment_Installment_FI_Preloan_Application |
(the Application's total Adjusted Monthly Payment in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and (Account Type has a value of Installment, Mortgage, or Open/30Day) and IsFromHost is true)) | |
|
Total Expenses Payment Installment Postloan |
Applicant Entity Total_Expenses_Payment_Installment_Postloan_Applicant |
If Application LoanType has a value of “Closed End” Then (Set the aggregate “Total Expenses Payment Installment Postloan” for the applicant to ((Application MonthlyPaymentAmount plus Application LoanRealEstate TotMthlyPaymentAmt) plus (the total of (AdjustedMonthlyPayment multiplied by (PercentageResponsible divided by 100)) in Liabilities filtered by IsExpense is true and AccountType has a value of “Installment, Mortgage, Open/30 day”)) Else (Set the aggregate “Total Expenses Payment Installment Postloan” for the applicant to (the total of (AdjustedMonthlyPayment multiplied by (PercentageResponsible divided by 100)) in Liabilities filtered by IsExpense is true and AccountType has a value of “Installment, Mortgage, Open/30 day”) |
|
Application Entity Total_Expenses_Payment_Installment_Postloan_Application |
If LoanType has a value of “Closed End” Then (Set the aggregate “Total Expenses Payment Installment Postloan” for the application to ((MonthlyPaymentAmount plus LoanRealEstate TotMthlyPaymentAmt) plus (the total of AdjustedMonthlyPayment in Liabilities filtered by IsExpense is true and IncludeInApplicationAggregate is true and AccountType has a value of “Installment, Mortgage, Open/30 day”)) Else( Set the aggregate “Total Expenses Payment Installment Postloan” for the application to (the total of AdjustedMonthlyPayment in Liabilities filtered by IsExpense is true and IncludeInApplicationAggregate is true and AccountType has a value of “Installment, Mortgage, Open/30 day”) |
|
|
Total Expenses Payment Installment Preloan |
Applicant Entity Total_Expenses_Payment_Installment_Preloan_Applicant |
(the Applicant's total (Adjusted Monthly Payment * (Percentage Responsible / 100) in Liabilities where IsExpense is true and (Account Type has a value of Installment, Mortgage, or Open/30 Day))) |
|
Application Entity Total_Expenses_Payment_Installment_Preloan_Application |
(the Application's total Adjusted Monthly Payment in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and (Account Type has a value of Installment, Mortgage, or Open/30Day))) | |
|
Total Expenses Payment Medical Open |
Applicant Entity Total_Expenses_Payment_Medical_Open_Applicant |
(the Applicant's total (Adjusted Monthly Payment * (Percentage Responsible / 100) in Liabilities where IsExpense is true and Trade Closed Type has a value of Not Closed and Trade Category has a value of Medical)) |
|
Application Entity Total_Expenses_Payment_Medical_Open_Application |
(the Application's total of Adjusted Monthly Payment in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and Trade Category has a value of Medical and Trade Closed Type has a value of Not Closed) | |
|
Total Expenses Payment Postloan |
Applicant Entity Total_Expenses_Payment_Postloan_Applicant |
Set the aggregate “Total Expenses Payment Postloan” for the applicant to ((Application MonthlyPaymentAmount plus Application LoanRealEstate TotMthlyPaymentAmt) plus (the total of (AdjustedMonthlyPayment multiplied by (PercentageResponsible divided by 100)) in Liabilities filtered by IsExpense is true)) |
|
Application Entity Total_Expenses_Payment_Postloan_Application |
Set the aggregate “Total Expenses Payment Postloan” for the application to ((MonthlyPaymentAmount plus LoanRealEstate TotMthlyPaymentAmt) plus (the total of AdjustedMonthlyPayment in Liabilities filtered by IsExpense is true and IncludeInApplicationAggregate is true)) | |
|
Total Expenses Payment Preloan |
Applicant Entity Total_Expenses_Payment_Preloan_Applicant |
(the Applicant's total (Adjusted Monthly Payment * (Percentage Responsible / 100) in Liabilities where IsExpense is true)) |
|
Application Entity Total_Expenses_Payment_Preloan_Application |
(the Application's total Adjusted Monthly Payment in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true) | |
|
Total Expenses Payment Real Estate Open |
Applicant Entity Total_Expenses_Payment_Real_Estate_Open_Applicant |
(the Applicant's total (Adjusted Monthly Payment * (Percentage Responsible / 100) in Liabilities where IsExpense is true and Trace Closed Type has a value of Not Closed and Trade Category has a value of Real Estate)) |
|
Application Entity Total_Expenses_Payment_Real_Estate_Open_Application |
(the Application's total Adjusted Monthly Payment in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and Trade Category has a value of Real Estate and Trade Closed Type has a value of Not Closed) | |
|
Total Expenses Payment Revolving FI Postloan |
Applicant Entity Total_Expenses_Payment_Revolving_FI_Postloan_Applicant |
If Application LoanType has a value of “Open End” Then (Set the aggregate “Total Expenses Payment Revolving Postloan” for the applicant to ((Application MonthlyPaymentAmount plus Application LoanRealEstate TotMthlyPaymentAmt) plus (the total of (AdjustedMonthlyPayment multiplied by (PercentageResponsible divided by 100)) in Liabilities filtered by IsExpense is true and AccountType has a value of “Credit Line, Revolving” and IsFromHost is true)) Else (Set the aggregate “Total Expenses Payment Revolving Postloan” for the applicant to (the total of (AdjustedMonthlyPayment multiplied by (PercentageResponsible divided by 100)) in Liabilities filtered by IsExpense is true and AccountType has a value of “Credit Line, Revolving” and IsFromHost is true) |
|
Application Entity Total_Expenses_Payment_Revolving_FI_Postloan_Application |
If LoanType has a value of “Open End”
Then (Set the aggregate “Total Expenses Payment Revolving FI Postloan” for the application to ((MonthlyPaymentAmount plus LoanRealEstate TotMthlyPaymentAmt) plus (the total of AdjustedMonthlyPayment in Liabilities filtered by IsExpense is true and IncludeInApplicationAggregate is true and AccountType has a value of “Credit Line, Revolving” and IsFromHost is true)) Else (Set the aggregate “Total Expenses Payment Revolving FI Postloan” for the application to (the total of AdjustedMonthlyPayment in Liabilities filtered by IsExpense is true and IncludeInApplicationAggregate is true and AccountType has a value of “Credit Line, Revolving” and IsFromHost is true) |
|
|
Total Expenses Payment Revolving FI Preloan |
Applicant Entity Total_Expenses_Payment_Revolving_FI_Preloan_Applicant |
(the Applicant's total (Adjusted Monthly Payment * (Percentage Responsible / 100) in Liabilities where IsExpense is true and (Account Type has a value of Credit Line, or Revolving) and IsFromHost is true) |
|
Application Entity Total_Expenses_Payment_Revolving_FI_Preloan_Application |
(the Application's total Adjusted Monthly Payment in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and (Account Type has a value of Credit Line, or Revolving) and IsFromHost is true) | |
|
Total Expenses Payment Revolving Postloan |
Applicant Entity Total_Expenses_Payment_Revolving_Postloan_Applicant |
If Application LoanType has a value of “Open End” Then (Set the aggregate “Total Expenses Payment Revolving Postloan” for the applicant to ((Application MonthlyPaymentAmount plus Application LoanRealEstate TotMthlyPaymentAmt) plus (the total of (AdjustedMonthlyPayment multiplied by (PercentageResponsible divided by 100)) in Liabilities filtered by IsExpense is true and AccountType has a value of “Credit Line, Revolving”)) Else (Set the aggregate “Total Expenses Payment Revolving Postloan” for the applicant to (the total of (AdjustedMonthlyPayment multiplied by (PercentageResponsible divided by 100)) in Liabilities filtered by IsExpense is true and AccountType has a value of “Credit Line, Revolving”) |
|
Application Entity Total_Expenses_Payment_Revolving_Postloan_Application |
If LoanType has a value of “Open End”
Then (Set the aggregate “Total Expenses Payment Revolving Postloan” for the application to ((MonthlyPaymentAmount plus LoanRealEstate TotMthlyPaymentAmt) plus (the total of AdjustedMonthlyPayment in Liabilities filtered by IsExpense is true and IncludeInApplicationAggregate is true and AccountType has a value of “Credit Line, Revolving”)) Else (Set the aggregate “Total Expenses Payment Revolving Postloan” for the application to (the total of AdjustedMonthlyPayment in Liabilities filtered by IsExpense is true and IncludeInApplicationAggregate is true and AccountType has a value of “Credit Line, Revolving”) |
|
|
Total Expenses Payment Revolving Preloan |
Applicant Entity Total_Expenses_Payment_Revolving_Preloan_Applicant |
(the Application's total Adjusted Limit n Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and (Account Type has a value of Credit Line, or Revolving)) |
|
Application Entity Total_Expenses_Payment_Revolving_Preloan_Application |
(the Application's total Adjusted Monthly Payment in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and (Account Type has a value of Credit Line, or Revolving)) | |
|
Total Expenses Payment Secured FI Postloan |
Applicant Entity Total_Expenses_Payment_Secured_FI_Postloan_Applicant |
If Application IsSecured is true Then (Set the aggregate “Total Expenses Payment Secured FI Postloan” for the applicant to ((Application MonthlyPaymentAmount plus Application LoanRealEstate TotMthlyPaymentAmt) plus (the total of (AdjustedMonthlyPayment multiplied by (PercentageResponsible divided by 100)) in Liabilities filtered by IsExpense is true and IsSecured is true and IsFromHost is true)) Else (Set the aggregate “Total Expenses Payment Secured FI Postloan” for the applicant to (the total of (AdjustedMonthlyPayment multiplied by (PercentageResponsible divided by 100)) in Liabilities filtered by IsExpense is true and IsSecured is true and IsFromHost is true) |
|
Application Entity Total_Expenses_Payment_Secured_FI_Postloan_Application |
If IsSecured is true Then (Set the aggregate “Total Expenses Payment Secured FI Postloan” for the application to ((MonthlyPaymentAmount plus LoanRealEstate TotMthlyPaymentAmt) plus (the total of AdjustedMonthlyPayment in Liabilities filtered by IsExpense is true and IncludeInApplicationAggregate is true and IsSecured is true and IsFromHost is true)) Else (Set the aggregate “Total Expenses Payment Secured FI Postloan” for the application to (the total of AdjustedMonthlyPayment in Liabilities filtered by IsExpense is true and IncludeInApplicationAggregate is true and IsSecured is true and IsFromHost is true) |
|
|
Total Expense Payment Secured FI Preloan |
Applicant Entity Total_Expenses_Payment_Secured_FI_Preloan_Applicant |
(the Applicant's total (Adjusted Monthly Payment * (Percentage Responsible / 100)) in Liabilities where IsExpense is true and IsSecured is true and IsFromHost is true) |
|
Application Entity Total_Expenses_Payment_Secured_FI_Preloan_Application |
(the Application's total (Adjusted Monthly Payment in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and IsSecured is true and IsFromHost is true) | |
|
Total Expense Payment Secured Postloan |
Applicant Entity Total_Expenses_Payment_Secured_Postloan_Applicant |
If Application IsSecured is true Then (Set the aggregate “Total Expenses Payment Secured Postloan” for the applicant to ((Application MonthlyPaymentAmount plus Application LoanRealEstate TotMthlyPaymentAmt) plus (the total of (AdjustedMonthlyPayment multiplied by (PercentageResponsible divided by 100)) in Liabilities filtered by IsExpense is true and IsSecured is true)) Else (Set the aggregate “Total Expenses Payment Secured Postloan” for the applicant to (the total of (AdjustedMonthlyPayment multiplied by (PercentageResponsible divided by 100)) in Liabilities filtered by IsExpense is true and IsSecured is true) |
|
Application Entity Total_Expenses_Payment_Secured_Postloan_Application |
If IsSecured is true Then (Set the aggregate “Total Expenses Payment Secured Postloan” for the application to ((MonthlyPaymentAmount plus LoanRealEstate TotMthlyPaymentAmt) plus (the total of AdjustedMonthlyPayment in Liabilities filtered by IsExpense is true and IncludeInApplicationAggregate is true and IsSecured is true)) Else (Set the aggregate “Total Expenses Payment Secured Postloan” for the application to (the total of AdjustedMonthlyPayment in Liabilities filtered by IsExpense is true and IncludeInApplicationAggregate is true and IsSecured is true) |
|
|
Total Expense Payment Secured Preloan |
Applicant Entity Total_Expenses_Payment_Secured_Preloan_Applicant |
(the Applicant's total (Adjusted Monthly Payment * (Percentage Responsible / 100)) in Liabilities where IsExpense is true and IsSecured is true) |
|
Application Entity Total_Expenses_Payment_Secured_Preloan_Application |
(the Application's total (Adjusted Monthly Payment in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and IsSecured is true) | |
|
Total Expenses Payment Unsecured FI Postloan |
Applicant Entity Total_Expenses_Payment_Unsecured_FI_Postloan_Applicant |
If the Application IsSecured is false Then (Application Monthly Payment Amount + (the Applicant's total Adjusted Monthly Payment Amount * (Percentage Responsible / 100) in Liabilities where Trade Closed Type has a value of Not Closed and IsSecured is false and IsFromHost is true) Else (the Applicant's total Adjusted Monthly Payment Amount * (Percentage Responsible / 100) in Liabilities whereTrade Closed Type has a value of Not Closed and IsSecured is false and IsFromHost is true) |
|
Application Entity Total_Expenses_Payment_Unsecured_FI_Postloan_Application |
If IsSecured is false Then (Application Monthly Payment Amount + (the Application's total Adjusted Monthly Payment Amount in Liabilities where IncludeInApplicationAggregates is true and Trade Closed Type has a value of Not Closed and IsSecured is false and IsFromHost is true) Else (the Application's total Adjusted Monthly Payment Amount in Liabilities where IncludeInApplicationAggregates is true and Trade Closed Type has a value of Not Closed and IsSecured is false and IsFromHost is true) |
|
|
Total Expenses Payment Unsecured FI Preloan |
Applicant Entity Total_Expenses_Payment_Unsecured_FI_Preloan_Applicant |
(the Applicant's total (Adjusted Monthly Payment * (Percentage Responsible / 100)) in Liabilities where IsExpense is true and IsSecured is false and IsFromHost is true) |
|
Application Entity Total_Expenses_Payment_Unsecured_FI_Preloan_Application |
(the Application's total (Adjusted Monthly Payment in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and IsSecured is false and IsFromHost is true) | |
|
Total Expenses Payment Unsecured Postloan |
Applicant Entity Total_Expenses_Payment_Unsecured_Postloan_Applicant |
If the Application IsSecured is false Then (Application Monthly Payment Amount + (the Applicant's total Adjusted Monthly Payment Amount * (Percentage Responsible / 100) in Liabilities where IsExpense is true and IsSecured is false) Else (the Applicant's total Adjusted Monthly Payment Amount * (Percentage Responsible / 100) in Liabilities where IsExpense is true and IsSecured is false) |
|
Application Entity Total_Expenses_Payment_Unsecured_Postloan_Application |
If IsSecured is false Then (Application Monthly Payment Amount + (the Application's total Adjusted Monthly Payment Amount in Liabilities where IncludeInApplicationAggregates is true and IsExpense is true and IsSecured is false) Else (the Application's total Adjusted Monthly Payment Amount in Liabilities where IncludeInApplicationAggregates is true and IsExpense is true and IsSecured is false) |
|
|
Total Expenses Payment Unsecured Preloan |
Applicant Entity Total_Expenses_Payment_Unsecured_Preloan_Applicant |
(the Applicant's total (Adjusted Monthly Payment * (Percentage Responsible / 100)) in Liabilities where IsExpense is true and IsSecured is false) |
|
Application Entity Total_Expenses_Payment_Unsecured_Preloan_Application |
(the Application's total (Adjusted Monthly Payment in Liabilities where IsExpense is true and IncludeInApplicationAggregates is true and IsSecured is false) | |
|
Total Income |
Applicant Entity Total_Income_Applicant |
(the Applicant's total Adjusted Monthly Income in Incomes where Income Type does not have a value of Previous Income) |
|
Application Entity Total_Income_Application |
(the Application's total Adjusted Monthly Income in Incomes where Income Type does not have a value of Previous Income and IncludeInApplicationAggregates is true) | |
|
Total Income Additional |
Applicant Entity Total_Income_Additional_Applicant |
(the Applicant's total Adjusted Monthly Income in Incomes where Income Type has a value of Additional Income) |
|
Application Entity Total_Income_Additional_Application |
(the Application's total Adjusted Monthly Income in Incomes where Income Type has a value of Additional Income and IncludeInApplicationAggregates is true) | |
|
Total Income Alimony |
Applicant Entity Total_Income_Alimony_Applicant |
(the Applicant's total Adjusted Monthly Income in Incomes where Income Type has a value of Alimony Income) |
|
Application Entity Total_Income_Alimony_Application |
(the Application's total Adjusted Monthly Income in Incomes where Income Type has a value of Alimony Income and IncludeInApplicationAggregates is true) | |
|
Total Income Child Support |
Applicant Entity Total_Income_Child_Support_Applicant |
(the Applicant's total Adjusted Monthly Income in Incomes where Income Type has a value of Child Support) |
|
Application Entity Total_Income_Child_Support_Application |
(the Application's total Adjusted Monthly Income in Incomes where Income Type has a value of Child Support and IncludeInApplicationAggregates is true) | |
|
Total Income Non Current |
Applicant Entity Total_Income_Non_Current_Applicant |
(the Applicant's total Adjusted Monthly Income in Incomes where Income Type does not have a value of Current Income) |
|
Application Entity Total_Income_Non_Current_Application |
(the Application's total Adjusted Monthly Income in Incomes where Income Type does not have a value of Current Income and IncludeInApplicationAggregates is true) | |
|
Total Income Other |
Applicant Entity Total_Income_Other_Applicant |
(the Applicant's total Adjusted Monthly Income in Incomes where Income Type has a value of Other) |
|
Application Entity Total_Income_Other_Application |
(the Application's total Adjusted Monthly Income in Incomes where Income Type has a value of Other and IncludeInApplicationAggregates is true) | |
|
Total Income Retirement |
Applicant Entity Total_Income_Retirement_Applicant |
(the Applicant's total Adjusted Monthly Income in Incomes where Income Type has a value of Retirement) |
|
Application Entity Total_Income_Retirement_Application |
(the Application's total Adjusted Monthly Income in Incomes where Income Type has a value of Retirement and IncludeInApplicationAggregates is true) | |
|
Total Income SSI |
Applicant Entity Total_Income_SSI_Applicant |
(the Applicant's total Adjusted Monthly Income in Incomes where Income Type has a value of Social Security) |
|
Application Entity Total_Income_SSI_Application |
(the Application's total Adjusted Monthly Income in Incomes where Income Type has a value of Social Security and IncludeInApplicationAggregates is true) | |
|
Total Trades Balance Credit Cards Open |
Applicant Entity Total_Trades_Balance_Credit_Cards_Open_Applicant |
(the Applicant's total (Adjusted Balance * (Percentage Responsible / 100) in Liabilities where Trade Closed Type has a value of Not Closed, and (Trade Category has a value of Credit Card, Department Store, or Miscellaneous Retail) |
|
Application Entity Total_Trades_Balance_Credit_Cards_Open_Application |
(the Application's total Adjusted Balance in Liabilities where Trade Closed Type has a value of Not Closed and IncludeInApplicationAggregates is true and Trade Category has a value of Education (Student Loans)) | |
|
Total Trades Balance Education Open |
Applicant Entity Total_Trades_Balance_Education_Open_Applicant |
(the Applicant's total (Adjusted Balance * (Percentage Responsible / 100) in Liabilities where Trade Closed Type has a value of Not Closed, and (Trade Category has a value of Credit Card, Department Store, or Miscellaneous Retail) |
|
Application Entity Total_Trades_Balance_Education_Open_Application |
(the Application's total Adjusted Balance in Liabilities where Trade Closed Type has a value of Not Closed and IncludeInApplicationAggregates is true and Trade Category has a value of Education (Student Loans)) | |
|
Total Trades Balance Installment Open Postloan |
Applicant Entity Total_Trades_Balance_Installment_Open_Postloan_Applicant |
If the Application Loan Type has a value of Closed End Then (Application Initial Loan Amount + (the Applicant's total Adjusted Balance * (Percentage Responsible / 100) in Liabilities where (Trade Closed Type has a value of Not Closed and Account Type has a value of Installment, Mortgage, Open/30 Day Else (the Applicant's total Adjusted Balance * (Percentage Responsible / 100) in Liabilities where (Trade Closed Type has a value of Not Closed and Account Type has a value of Installment, Mortgage, Open/30 Day |
|
Application Entity Total_Trades_Balance_Installment_Open_Postloan_Application |
If the Application Loan Type has a value of Closed End Then (Application Initial Loan Amount + (the Application's total Adjusted Balance in Liabilities where IncludeInApplicationAggregates is true and (Trade Closed Type has a value of Not Closed and Account Type has a value of Installment, Mortgage, Open/30 Day Else (the Application's total Adjusted Balance in Liabilities where IncludeInApplicationAggregates is true and (Trade Closed Type has a value of Not Closed and Account Type has a value of Installment, Mortgage, Open/30 Day |
|
|
Total Trades Balance Installment Open Preloan |
Applicant Entity Total_Trades_Balance_Installment_Open_Preloan_Applicant |
(the Applicant's total Adjusted Balance * (Percentage Responsible / 100) in Liabilities where IncludeInApplicationAggregates is true and (Trade Closed Type has a value of Not Closed and Account Type has a value of Installment, Mortgage, Open/30 Day |
|
Application Entity Total_Trades_Balance_Installment_Open_Preloan_Application |
(the Application's total Adjusted Balance in Liabilities where IncludeInApplicationAggregates is true and (Trade Closed Type has a value of Not Closed and Account Type has a value of Installment, Mortgage, Open/30 Day | |
|
Total Trades Balance Medical Open |
Applicant Entity Total_Trades_Balance_Medical_Open_Applicant |
(the Applicant's total (Adjusted Balance * (Percentage Responsible / 100) in Liabilities where Trade Closed Type has a value of Not Closed and Trade Category has a value of Medical) |
|
Application Entity Total_Trades_Balance_Medical_Open_Application |
(the Application's total Adjusted Balance in Liabilities where Trade Closed Type has a value of Not Closed and IncludeInApplicationAggregates is true and Trade Category has a value of Medical) | |
|
Total Trades Balance Open Postloan |
Applicant Entity Total_Trades_Balance_Open_Postloan_Applicant |
(Application's Initial Loan Amount + (the Applicant's total (Adjusted Balance * (Percentage Responsible / 100) in Liabilities where Trade Closed Type has a value of Not Closed)) |
|
Application Entity Total_Trades_Balance_Open_Postloan_Application |
(Application's Initial Loan Amount + (the Application's total Adjusted Balance in Liabilities where IncludeInApplicationAggregates is true and Trade Closed Type has a value of Not Closed)) | |
|
Total Trades Balance Open Preloan |
Applicant Entity Total_Trades_Balance_Open_Preloan_Applicant |
(the Applicant's total (Adjusted Balance * (Percentage Responsible / 100) in Liabilities where Trade Closed Type has a value of Not Closed)) |
|
Application Entity Total_Trades_Balance_Open_Preloan_Application |
(the Application's total Adjusted Balance in Liabilities where IncludeInApplicationAggregates is true and Trade Closed Type has a value of Not Closed) | |
|
Total Trades Balance Real Estate Open |
Applicant Entity Total_Trades_Balance_Real_Estate_Open_Applicant |
(the Applicant's total (Adjusted Balance * (Percentage Responsible / 100) in Liabilities where Trade Closed Type has a value of Not Closed and Trade Category has a value of Real Estate)) |
|
Application Entity Total_Trades_Balance_Real_Estate_Open_Application |
(the Application's total Adjusted Balance in Liabilities where IncludeInApplicationAggregates is true and Trade Closed Type has a value of Not Closed and Trade Category has a value of Real Estate) | |
|
Total Trades Balance Revolving Open Postloan |
Applicant Entity Total_Trades_Balance_Revolving_Open_Postloan_Applicant |
If the Application Loan Type has a value of Open End Then (Application Initial Loan Amount + (the Applicant's total Adjusted Balance * (Percentage Responsible / 100) in Liabilities where ITrade Closed Type has a value of Not Closed and (Account Type has a value of Credit Line, or Revolving))) Else (the Applicant's total Adjusted Balance * (Percentage Responsible / 100) in Liabilities whereTrade Closed Type has a value of Not Closed and (Account Type has a value of Credit Line, or Revolving))) |
|
Application Entity Total_Trades_Balance_Revolving_Open_Postloan_Application |
If the Application Loan Type has a value of Open End Then (Application Initial Loan Amount + (the Application's total Adjusted Balance in Liabilities where IncludeInApplicationAggregates is true and Trade Closed Type has a value of Not Closed and (Account Type has a value of Credit Line, or Revolving))) Else (the Application's total Adjusted Balance in Liabilities where IncludeInApplicationAggregates is true and Trade Closed Type has a value of Not Closed and (Account Type has a value of Credit Line, or Revolving) |
|
|
Total Trades Balance Revolving Open Preloan |
Applicant Entity Total_Trades_Balance_Revolving_Open_Preloan_Applicant |
(the Applicant's total Adjusted Balance * (Percentage Responsible / 100) in Liabilities where IncludeInApplicationAggregates is true and Trade Closed Type has a value of Not Closed and (Account Type has a value of Credit Line, or Revolving))) |
|
Application Entity Total_Trades_Balance_Revolving_Open_Preloan_Application |
(the Application's total Adjusted Balance in Liabilities where IncludeInApplicationAggregates is true and Trade Closed Type has a value of Not Closed and (Account Type has a value of Credit Line, or Revolving) | |
|
Total Trades Balance Secured Open Postloan |
Applicant Entity Total_Trades_Balance_Secured_Open_Postloan_Applicant |
If the Application IsSecured is true Then (Application Initial Loan Amount + (the Applicant's total Adjusted Balance * (Percentage Responsible / 100) in Liabilities where Trade Closed Type has a value of Not Closed and IsSecured is true) Else (the Applicant's total Adjusted Balance * (Percentage Responsible / 100) in Liabilities whereTrade Closed Type has a value of Not Closed and IsSecured is true) |
|
Application Entity Total_Trades_Balance_Secured_Open_Postloan_Application |
If IsSecured is true Then (Application Initial Loan Amount + (the Application's total Adjusted Balance in Liabilities where IncludeInApplicationAggregates is true and Trade Closed Type has a value of Not Closed and IsSecured is true) Else (the Application's total Adjusted Balance in Liabilities where IncludeInApplicationAggregates is true and Trade Closed Type has a value of Not Closed and IsSecured is true) |
|
|
Total Trades Balance Secured Open Preloan |
Applicant Entity Total_Trades_Balance_Secured_Open_Preloan_Applicant |
(the Applicant's total (Adjusted Balance * (Percentage Responsible / 100)) in Liabilities where TradeClosedType has a value of Not Closed and IsSecured is true) |
|
Application Entity Total_Trades_Balance_Secured_Open_Preloan_Application |
(the Application's total (Adjusted Balance in Liabilities where IncludeInApplicationAggregates is true and TradeCloseType has a value of Not Closed and IsSecured is true) | |
|
Total Balance Unsecured Open Postloan |
Applicant Entity Total_Trades_Balance_Unsecured_Open_Postloan_Applicant |
If the Application IsSecured is false Then (Application Initial Loan Amount + (the Applicant's total Adjusted Balance * (Percentage Responsible / 100) in Liabilities where Trade Closed Type has a value of Not Closed and IsSecured is false) Else (the Applicant's total Adjusted Balance * (Percentage Responsible / 100) in Liabilities whereTrade Closed Type has a value of Not Closed and IsSecured is false) |
|
Application Entity Total_Trades_Balance_Unsecured_Open_Postloan_Application |
If IsSecured is false Then (Application Initial Loan Amount + (the Application's total Adjusted Balance in Liabilities where IncludeInApplicationAggregates is true and Trade Closed Type has a value of Not Closed and IsSecured is false) Else (the Application's total Adjusted Balance in Liabilities where IncludeInApplicationAggregates is true and Trade Closed Type has a value of Not Closed and IsSecured is false) |
|
|
Total Balance Unsecured Open Preloan |
Applicant Entity Total_Trades_Balance_Unsecured_Open_Preloan_Applicant |
(the Applicant's total (Adjusted Balance * (Percentage Responsible / 100)) in Liabilities where TradeClosedType has a value of Not Closed and IsSecured is false) |
|
Application Entity Total_Trades_Balance_Unsecured_Open_Preloan_Application |
(the Application's total (Adjusted Balance in Liabilities where IncludeInApplicationAggregates is true and TradeCloseType has a value of Not Closed and IsSecured is false) | |
|
Total Trades Balance Vehicle Open |
Applicant Entity Total_Trades_Balance_Vehicle_Open_Applicant |
(the Applicant's total (Adjusted Balance * (Percentage Responsible / 100) in Liabilities where Trade Closed Type has a value of Not Closed and (Trade Category has a value of Automobile, Boat/Yacht, or Recreational Vehicle (Camper, Motor Home)))) |
|
Application Entity Total_Trades_Balance_Vehicle_Open_Application |
(the Application's total Adjusted Balance in Liabilities where IncludeInApplicationAggregates is true and Trade Closed Type has a value of Not Closed and (Trade Category has a value of Automobile, Boat/Yacht, or Recreational Vehicle (Camper, Motor Home))) | |
|
Total Trades Balloon Open Postloan |
Applicant Entity Total_Trades_Balloon_Open_Postloan_Applicant |
(Application Balloon Amount + (the Applicant's total (Balloon Amount * (Percentage Responsible / 100) in Liabilities where Trade Closed Type has a value of Not Closed)) |
|
Application Entity Total_Trades_Balloon_Open_Postloan_Application |
(Application Balloon Amount + (the Application's total Balloon Amount in Liabilities where IncludeInApplicationAggregates is true and Trade Closed Type has a value of Not Closed)) | |
|
Total Trades Balloon Open Preloan |
Applicant Entity Total_Trades_Balloon_Open_Preloan_Applicant |
(the Applicant's total (Balloon Amount * (Percentage Responsible / 100) in Liabilities where Trade Closed Type has a value of Not Closed)) |
|
Application Entity Total_Trades_Balloon_Open_Preloan_Application |
(the Application's total Balloon Amount in Liabilities where IncludeInApplicationAggregates is true and Trade Closed Type has a value of Not Closed)) | |
|
Total Trades Limit Credit Cards Open |
Applicant Entity Total_Trades_Limit_Credit_Cards_Open_Applicant |
(the Applicant's total (Limit in Liabilities where Trade Closed Type has a value of Not Closed and Trade Category has a value of Credit Card, Department Store, or Miscellaneous Retail)) |
|
Application Entity Total_Trades_Limit_Credit_Cards_Open_Application |
(the Application's total Balloon Amount in Liabilities where IncludeInApplicationAggregates is true and Trade Closed Type has a value of Not Closed and Trade Category has a value of Credit Card, Department Store, or Miscellaneous Retail)) | |
|
Total Trades Limit Revolving Open Postloan |
Applicant Entity Total_Trades_Limit_Revolving_Open_Postloan_Applicant |
If the Application Loan Type has a value of Open End Then (Application Initial Loan Amount + (the Applicant's total Limit in Liabilities whereTrade Closed Type has a value of Not Closed and (Account Type has a value of Credit Line, or Revolving))) Else (the Applicant's total Limit in Liabilities where Trade Closed Type has a value of Not Closed and (Account Type has a value of Credit Line, or Revolving))) |
|
Application Entity Total_Trades_Limit_Revolving_Open_Postloan_Application |
If the Application Loan Type has a value of Open End Then (Application Initial Loan Amount + (the Application's total Limit in Liabilities where IncludeInApplicationAggregates is true and Trade Closed Type has a value of Not Closed and (Account Type has a value of Credit Line, or Revolving))) Else (the Application's total Limit in Liabilities where IncludeInApplicationAggregates is true and Trade Closed Type has a value of Not Closed and (Account Type has a value of Credit Line, or Revolving)) |
|
|
Total Trades Limit Revolving Open Preloan |
Applicant Entity Total_Trades_Limit_Revolving_Open_Preloan_Applicant |
(the Applicant's total Limit in Liabilities whereTrade Closed Type has a value of Not Closed and (Account Type has a value of Credit Line, or Revolving))) |
|
Application Entity l_Trades_Limit_Revolving_Open_Preloan_Application |
(the Application's total Limit in Liabilities where IncludeInApplicationAggregates is true and Trade Closed Type has a value of Not Closed and (Account Type has a value of Credit Line, or Revolving)) | |
|
Total Trades Limit Unsecured Open Postloan |
Applicant Entity Total_Trades_Limit_Unsecured_Open_Postloan_Applicant |
If the Application IsSecured is false Then (Application Initial Loan Amount + (the Applicant's total Limit * (Percentage Responsible / 100) in Liabilities where Trade Closed Type has a value of Not Closed and IsSecured is false) Else (the Applicant's total Limit * (Percentage Responsible / 100) in Liabilities whereTrade Closed Type has a value of Not Closed and IsSecured is false) |
|
Application Entity Total_Trades_Limit_Unsecured_Open_Postloan_Application |
If IsSecured is false Then (Application Initial Loan Amount + (the Application's total Limit in Liabilities where IncludeInApplicationAggregates is true and Trade Closed Type has a value of Not Closed and IsSecured is false) Else (the Application's total Limit in Liabilities where IncludeInApplicationAggregates is true and Trade Closed Type has a value of Not Closed and IsSecured is false) |
|
|
Total Trades Limit Unsecured Open Preloan |
Applicant Entity Total_Trades_Limit_Unsecured_Open_Preloan_Applicant |
(the Applicant's total (Adjusted Limit * (Percentage Responsible / 100)) in Liabilities where TradeClosedType has a value of Not Closed and IsSecured is false) |
|
Application Entity Total_Trades_Limit_Unsecured_Open_Preloan_Application |
(the Application's total (Adjusted Limit in Liabilities where IncludeInApplicationAggregates is true and TradeCloseType has a value of Not Closed and IsSecured is false) | |
|
Total Trades Payment Installment Open Postloan |
Applicant Entity Total_Trades_Payment_Installment_Open_Postloan_Applicant |
If Application LoanType has a value of “Closed End” Then (Set the aggregate “Total Trades Payment Installment Open Postloan” for the applicant to ((Application MonthlyPaymentAmount plus Application LoanRealEstate TotMthlyPaymentAmt) plus (the total of (AdjustedMonthlyPayment multiplied by (PercentageResponsible divided by 100)) in Liabilities filtered by TradeClosedType has a value of “Not Closed” and AccountType has a value of “Installment, Mortgage, Open/30 day)) Else (Set the aggregate “Total Trades Payment Installment Open Postloan” for the applicant to (the total of (AdjustedMonthlyPayment multiplied by (PercentageResponsible divided by 100)) in Liabilities filtered by TradeClosedType has a value of “Not Closed” and AccountType has a value of Installment, Mortgage, Open/30 day) |
|
Application Entity Total_Trades_Payment_Installment_Open_Postloan_Application |
If LoanType has a value of “Closed End” Then (Set the aggregate “Total Trades Payment Installment Open Postloan” for the application to ((MonthlyPaymentAmount plus LoanRealEstate TotMthlyPaymentAmt) plus (the total of AdjustedMonthlyPayment in Liabilities filtered by IncludeInApplicationAggregate is true and TradeClosedType has a value of “Not Closed” and AccountType has a value of “Installment, Mortgage, Open/30 day”)) Else (Set the aggregate “Total Trades Payment Installment Open Postloan” for the application to (the total of AdjustedMonthlyPayment in Liabilities filtered by IncludeInApplicationAggregate is true and TradeClosedType has a value of “Not Closed” and AccountType has a value of “Installment, Mortgage, Open/30 day”) |
|
|
Total Trades Payment Installment Open Preloan |
Applicant Entity Total_Trades_Payment_Installment_Open_Preloan_Applicant |
(the Applicant's total Adjusted Monthly Payment * (Percentage Responsible / 100) in Liabilities where (Trade Closed Type has a value of Not Closed and Account Type has a value of Installment, Mortgage, Open/30 Day))) |
|
Application Entity Total_Trades_Payment_Installment_Open_Preloan_Application |
(the Application's total Adjusted Monthly Payment in Liabilities where IncludeInApplicationAggregates is true and (Trade Closed Type has a value of Not Closed and Account Type has a value of Installment, Mortgage, Open/30 Day)) | |
|
Total Trades Payment Open Postloan |
Applicant Entity Total_Trades_Payment_Open_Postloan_Applicant |
Set the aggregate “Total Trades Payment Open Postloan” for the applicant to ((Application MonthlyPaymentAmount plus Application LoanRealEstate TotMthlyPaymentAmt) plus (the total of (AdjustedMonthlyPayment multiplied by (PercentageResponsible divided by 100)) in Liabilities filtered by TradeClosedType has a value of “Not Closed”)) |
|
Application Entity Total_Trades_Payment_Open_Postloan_Application |
Set the aggregate “Total Trades Payment Open Postloan” for the application to ((MonthlyPaymentAmount plus LoanRealEstate TotMthlyPaymentAmt) plus (the total of AdjustedMonthlyPayment in Liabilities filtered by IncludeInApplicationAggregate is true and TradeClosedType has a value of “Not Closed”)) | |
|
Total Trades Payment Open Preloan |
Applicant Entity Total_Trades_Payment_Open_Preloan_Applicant |
(the Applicant's total Adjusted Monthly Payment * (Percentage Responsible / 100) in Liabilities where (Trade Closed Type has a value of Not Closed))) |
|
Application Entity Total_Trades_Payment_Open_Preloan_Application |
(the Application's total Adjusted Monthly Payment in Liabilities where IncludeInApplicationAggregates is true and Trade Closed Type has a value of Not Closed) | |
|
Total Trades Payment Revolving Open Postloan |
Applicant Entity Total_Trades_Payment_Revolving_Open_Postloan_Applicant |
If Application LoanType has a value of “Open End”
Then (Set the aggregate “Total Trades Payment Revolving Open Postloan” for the applicant to ((Application MonthlyPaymentAmount plus Application LoanRealEstate TotMthlyPaymentAmt) plus (the total of (AdjustedMonthlyPayment multiplied by (PercentageResponsible divided by 100)) in Liabilities filtered by TradeClosedType has a value of “Not Closed” and AccountType has a value of “Credit Line, Revolving”)) Else (Set the aggregate “Total Trades Payment Revolving Open Postloan” for the applicant to (the total of (AdjustedMonthlyPayment multiplied by (PercentageResponsible divided by 100)) in Liabilities filtered by TradeClosedType has a value of “Not Closed” and AccountType has a value of “Credit Line, Revolving”) |
|
Application Entity Total_Trades_Payment_Revolving_Open_Postloan_Application |
If LoanType has a value of “Open End”
Then (Set the aggregate “Total Trades Payment Revolving Open Postloan” for the application to ((MonthlyPaymentAmount plus LoanRealEstate TotMthlyPaymentAmt) plus (the total of AdjustedMonthlyPayment in Liabilities filtered by IncludeInApplicationAggregate is true and TradeClosedType has a value of “Not Closed” and AccountType has a value of “Credit Line, Revolving”)) Else (Set the aggregate “Total Trades Payment Revolving Open Postloan” for the application to (the total of AdjustedMonthlyPayment in Liabilities filtered by IncludeInApplicationAggregate is true and TradeClosedType has a value of “Not Closed” and AccountType has a value of “Credit Line, Revolving”) |
|
|
Total Trades Payment Revolving Open Preloan |
Applicant Entity Total_Trades_Payment_Revolving_Open_Preloan_Applicant |
(the Applicant's total Adjusted Monthly Payment * (Percentage Responsible / 100) in Liabilities whereTrade Closed Type has a value of Not Closed and (Account Type has a value of Credit Line, or Revolving))) |
|
Application Entity Total_Trades_Payment_Revolving_Open_Preloan_Application |
(the Application's total Adjusted Monthly Payment in Liabilities where IncludeInApplicationAggregates is true and Trade Closed Type has a value of Not Closed and (Account Type has a value of Credit Line, or Revolving)) | |
|
Total Trades Payment Secured Open Postloan |
Applicant Entity Total_Trades_Payment_Secured_Open_Postloan_Applicant |
If Application IsSecured is true Then (Set the aggregate “Total Trades Payment Secured Open Postloan” for the applicant to ((Application MonthlyPaymentAmount plus Application LoanRealEstate TotMthlyPaymentAmt) plus (the total of (AdjustedMonthlyPayment multiplied by (PercentageResponsible divided by 100)) in Liabilities filtered by TradeClosedType has a value of “Not Closed” and IsSecured is true)) Else (Set the aggregate “Total Trades Payment Secured Open Postloan” for the applicant to (the total of (AdjustedMonthlyPayment multiplied by (PercentageResponsible divided by 100)) in Liabilities filtered by TradeClosedType has a value of “Not Closed” and IsSecured is true) |
|
Application Entity Total_Trades_Payment_Secured_Open_Postloan_Application |
If IsSecured is true Then( Set the aggregate “Total Trades Payment Secured Open Postloan” for the application to ((MonthlyPaymentAmount plus LoanRealEstate TotMthlyPaymentAmt) plus (the total of AdjustedMonthlyPayment in Liabilities filtered by IncludeInApplicationAggregate is true and TradeClosedType has a value of “Not Closed” and IsSecured is true)) Else (Set the aggregate “Total Trades Payment Secured Open Postloan” for the application to (the total of AdjustedMonthlyPayment in Liabilities filtered by IncludeInApplicationAggregate is true and TradeClosedType has a value of “Not Closed” and IsSecured is true) |
|
|
Total Trades Payment Secured Open Preloan |
Applicant Entity |
(the Applicant's total (Adjusted Monthly Payment * (Percentage Responsible / 100)) in Liabilities where TradeClosedType has a value of Not Closed and IsSecured is true) |
|
Application Entity |
(the Application's total (Adjusted Monthly Payment in Liabilities where IncludeInApplicationAggregates is true and TradeCloseType has a value of Not Closed and IsSecured is true) | |
|
Total Trade Payment Unsecured Open Postloan |
Applicant Entity Total_Trades_Payment_Unsecured_Open_Postloan_Applicant |
If the Application IsSecured is false Then (Application Monthly Payment Amount + (the Applicant's total Adjusted Monthly Payment * (Percentage Responsible / 100) in Liabilities whereTrade Closed Type has a value of Not Closed and IsSecured is false) Else (the Applicant's total Adjusted Monthly Payment * (Percentage Responsible / 100) in Liabilities whereTrade Closed Type has a value of Not Closed and IsSecured is false) |
|
Application Entity Total_Trades_Payment_Unsecured_Open_Postloan_Application |
If IsSecured is false Then (Application Monthly Payment Amount + (the Application's total Adjusted Monthly Payment in Liabilities where IncludeInApplicationAggregates is true and Trade Closed Type has a value of Not Closed and IsSecured is false)) Else (the Application's total Adjusted Monthly Payment in Liabilities where IncludeInApplicationAggregates is true and Trade Closed Type has a value of Not Closed and IsSecured is false) |
|
|
Total Trades Payment Unsecured Open Preloan |
Applicant Entity Total_Trades_Payment_Unsecured_Open_Preloan_Applicant |
(the Applicant's total (Adjusted Monthly Payment * (Percentage Responsible / 100)) in Liabilities where TradeClosedType has a value of Not Closed and IsSecured is false) |
|
Application Entity Total_Trades_Payment_Unsecured_Open_Preloan_Application |
(the Application's total (Adjusted Monthly Payment in Liabilities where IncludeInApplicationAggregates is true and TradeCloseType has a value of Not Closed and IsSecured is false) | |
|
Total Trades Payment Vehicle Open |
Applicant Entity Total_Trades_Payment_Vehicle_Open_Applicant |
(the Applicant's total Adjusted Monthly Payment * (Percentage Responsible / 100) in Liabilities where (Trade Closed Type has a value of Not Closed and Trade Category has a value of Automobile, Boat/Yacht, Recreational Vehicle (Camper, Motor Home))) |
|
Application Entity Total_Trades_Payment_Vehicle_Open_Application |
(the Application's total Adjusted Monthly Payment in Liabilities where IncludeInApplicationAggregates is true and (Trade Closed Type has a value of Not Closed and Trade Category has a value of Automobile, Boat/Yacht, Recreational Vehicle (Camper, Motor Home))) |
 |
Aggregates are assigned at the sub-product level within the Table Entries tab in Loan Application Types and/or Account Application Types. |
The following system-defined rules are available within the Calculate Rules category:
| Rule | Description | ||
| CalculateRightOfRescissionDate | If ClosingDate is not blank and RealEstateType is Home Equity, sets the Rescission Date field to be the closing date plus 3 business days. | ||
| Calc_AvailableEquity | Sets the AvailableEquity field on RE collateral = (CollateralValue*(EquityLendingCap/100)) – TotalLienAmount | ||
| CalculateDebtProtectionFinancedFlag |
Sets the IsDebtProtectionFinanced to true or false based on the value of the Real Estate Type and Loan Type.
|
||
| SetAdditionalPrincipalPayment | If PaymentType has a value of "Interest Only with Periodic Principal Payments," sets the additional principal payment amount based on the requested amount, term, and additional principal payment frequency. | ||
| Set_CalculateMAPRFlag | Sets CalculateMAPR to true when the RealEstateType has a value of "None. | ||
| Set_ChargeInterestOnPremiumFlag | Sets the IsChargeInterestOnPremium field to true or false based on the value of the Real Estate Type and Loan Type. | ||
| SetEstimatedAmountAndPayOff |
If LoanRealEstate IsCalculateEstimatedValues is true and LoanRealEstate GFEDisclosureDate is equal to Today, sets LoanRealEstate CDEstimatedLoanAmount to FinalLoanAmount and LoanRealEstate CDEstimatedPayoffsandPayments to the total of Amount in Fundings where all of the following are true:
|
||
| Set_Lender_Credit | Sets LoanRealEstate CDLenderCredits to the total of ActualAmount in Fees filtered by PaidBy has a value of "Lender." | ||
| Set_Lender_Credits_Estimated | If LoanRealEstate IsCalculateEstimatedValue is true and LoanRealEstate GFEDisclosureDate is equal to Today, sets LoanRealEstate LenderCreditsEstimated to the total of EstimatedAmount in Fees filtered by PaidBy has a value of "Lender." |
The following system-defined rule is available within the CrossSellProduct Rules category to pitch an Insurance Quote Cross-sell Product for the CUNA TruStage connector:
| Rule | Description |
| TruStageInsuranceQuote |
If all of the following are true, then pitch [select a cross-sell product] where product = Insurance Quote:
|
|
For more information, please see the Configuring the Connector topic in the CUNA TruStage connector guide. |
The following system-defined rule is available within the Disbursement Rules category:
| Rule | Description | ||
| Disb_SetDueDates |
If Payment Frequency = Semi-Monthly and the day of the month from FirstDueDate is less than or equal to 15, then sets FirstDueDateDay field to be the day of the month from FirstDueDate and sets SecondDueDateDay to be the (FirstDueDateDay + 15).
Else then sets SecondDueDateDay to be the day of the month from FirstDueDate and sets FirstDueDateDay to be the (SecondDueDateDay – 15).
|
The following system-defined rules are available within the Event Processing Rules category:
 |
To view examples of the following rules, as well as custom rules that can be authored to set HMDA fields, please see Appendix B in the HMDA Connector Guide. |
| Rule | Description |
| HMDA_Set_Balloon_Payment |
Sets the IsBalloon Payment to true in a HMDA loan when the Payment Type is set to Balloon. |
| HMDA_Set_Joint_Credit_Model |
Sets the Credit Score Model for the joint applicant in a HMDA loan. |
| HMDA_Set_Originator |
Sets the value of the Originator for the HMDA loan.
|
| HMDA_Set_Primary_Credit_Model |
Sets the Credit Score Model for the primary applicant in a HMDA loan. |
|
HMDA_Set_Underwriting |
Sets the HMDA Underwriting System and Result to true when an application is identified as a HMDA loan. |
Several system standard rules have been pre-configured in Rules Management to provide institutions with out-of-the-box rule logic that can used to automatically set responses to HYLS questions based on application and/or applicant data. The following rules are available under the Event Processing category in Rules Management to automatically set HYLS responses in an application:
| Rule Name | Rule Logic | ||
| Set_HYLS_ActiveMember | The number of years the applicant has been active with the financial institution. | ||
| Set_HYLS_TotalAmountOnDeposit | The total dollar amount on deposit with the financial institution. | ||
| Set_HYLS_NbrSatifactoryLoansExcessOf500 | The total number of open or paid loans with the financial institution in excess of $500. | ||
| Set_HYLS_HighestSatifactoryLoanAmount | The highest dollar amount of any loan financed with the financial institution. This rule is run at the applicant level. | ||
| Set_HYLS_Residence | The number of consecutive years that the applicant has been at the current and previous residence. | ||
| Set_HYLS_Employment | The number of consecutive years that the applicant has been working at his or her current and previous jobs. | ||
| Set_HYLS_ValidFICOScore |
For a score to be valid, the applicant must meet the following requirements:
|
||
| Set_HYLS_FICOScore_NoCreditFlaws | A flaw is defined as a current delinquency, collection account, or public records (within the past five years). This rule is run at the applicant level. | ||
| Set_HYLS_NbrIquiries | The number of inquiries on the credit report in the past 24 months. | ||
| Set_HYLS_NbrOfTradelines_PercentageOfMemberAge | The number of total trade lines compared to the applicant's age. | ||
| Set_HYLS_NewTradelinesOpened | The number of trade lines opened in the past 24 months, including collections, authorized users, student loans, etc. | ||
| Set_HYLS_TotalAmountPastDue | The total dollar amount that the applicant is past due across all creditors, at the time that he or she applied for the loan. This rule is run at the applicant level. | ||
| Set_HYLS_LoanToValue | For used vehicles, take the lower retail value from the third party source (KBB or NADA) or the actual purchase price. For new vehicles, take the lower of the MSRP or the purchase price; include taxes, insurance, and add-ons. | ||
| Set_HYLS_NbrOfVehicleLoans | Include any vehicle loan with the financial institution, or another financial institution opened in the past 5 years. | ||
| Set_HYLS_ExtendedTermFinancing |
For all consumer loans (personal and vehicle), excluding mortgages, home equity loans, and loans for boats and RVs.
|
||
| Set_HYLS_NewVehicleLoanVsAGI | The new vehicle loan request amount compared to the applicant’s annual gross income. | ||
| Set_HYLS_TotalSecuredLoanBalancesOutstandingVsAGI | The total amount being borrowed on the new vehicle loan request, plus any amount owed on the other secured loans, compared to the applicant’s annual gross income. This rule is run at the applicant level. | ||
| Set_HYLS_DebtToIncome | The applicant’s total monthly payments (including the new loan payment) as a percentage of the applicant’s monthly gross income. | ||
| Set_HYLS_TotalOutstandingUnsecuredDebtVsAGI | The total outstanding unsecured debt, including the new loan if unsecured, (revolving, installments, vehicles that are upside down, and any open collection, charge-off/write-off dollar amounts) as a percentage of the applicants annual gross income. This rule is run at the applicant level. | ||
| Set_HYLS_TotalUnsecuredAmountOutstanding | A count all outstanding unsecured debt for the applicant, including credit cards, unsecured line of credits, signature loans, open collection dollar amounts, any dollar amount where the applicant is upside down on their vehicle loan, as well as the new loan request (if applicable); exclude any debt being paid off with the new loan. | ||
| Set_HYLS_TotalMortgageDebtVsAGI | The amount owed on all outstanding mortgage(s) divided by the applicant's annual gross income. | ||
| Set_HYLS_AvailableEquityInRealEstate | The total equity amount in any home that the applicant currently owns. Value of the home minus any outstanding mortgage loans. | ||
| Set_HYLS_TotalAmountOfAddOns | A total of any service and/or extended warranties, GAP insurance, or disability/life insurance sold at the dealership. | ||
| Set_HYLS_NegativeEquityAddOn_TradeIn | Any negative dollar amount difference from the trade-in allowance versus what is owed. | ||
| Set_HYLS_CashDownPayment | The amount of cash submitted by the applicant as a down payment. | ||
| Set_HYLS_LoanAmountVsTerm |
For all consumer loans (personal and vehicle), excluding mortgages, home equity loans, and loans for boats and RVs.
|
||
| Calculate_HYLSConsecutiveEmployment | Calculates the applicant’s length of consecutive employment for the HYLS Connector. | ||
| Set_HYLS_ApplicationType | Identifies if the application is a Direct or Indirect application. | ||
| Set_HYLS_FICOScore_NoCreditFlaws_Application | A flaw is defined as a current delinquency, collection account, or public records (within the past five years). This rule is run at the application level. | ||
| Set_HYLS_HighestSatisfactoryLoanAmount_Application | The highest dollar amount of any loan financed with the financial institution. This rule is run at the application level. | ||
| Set_HYLS_IsJoint |
Determines if the application is considered a Joint application based on HYLS criteria.
|
||
| Set_HYLS_TotalAmountPastDue_Application | The total dollar amount past due across all creditors on the application, at the time that the applicant applied for the loan. This rule is run at the application level. | ||
| Set_HYLS_TotalOutstandingUnsecuredDebtVsAGI_Application | The total outstanding unsecured debt on the application, including the new loan if unsecured, as a percentage of the applicants annual gross income. This rule is run at the application level. | ||
| Set_HYLS_TotalSecuredLoanBalancesOutstandingVsAGI_Application | The total amount being borrowed on the new vehicle loan request, plus any amount owed on the other secured loans, compared to the applicant’s annual gross income. This rule is run at the application level. | ||
| Set_HYLS_TotalUnsecuredAmountOutstanding_Application | A count all outstanding unsecured debt, including credit cards, unsecured line of credits, signature loans, open collection dollar amounts, any dollar amount where the applicant is upside down on their vehicle loan, as well as the new loan request (if applicable); exclude any debt being paid off with the new loan. This rule is run at the application level. |
| Ratio Name | Rule Entity Level and Name | Calculation |
| Annual Unsecured Debt to Income Postloan |
Applicant Entity Annual_Unsecured_DTI_Postloan_Applicant |
If Applicant's Total Income = 0 Then 0 Else (Applicant's Total Trades Payment Unsecured Open Postloan / Applicant's Total Income) * 12 |
|
|
Application Entity Annual_Unsecured_DTI_Postloan_Application |
If Application's Total Income = 0 Then 0 Else (Application's Total Trades Payment Unsecured Open Postloan / Application's Total Income) * 12 |
|
Annual Unsecured Debt to Income Preloan |
Applicant Entity Annual_Unsecured_DTI_Preloan_Applicant |
If Applicant’s Total Income = 0 Then 0 Else (Applicant's Total Trades Payment Unsecured Open Preloan / Applicant’s Total Income) * 12 |
|
|
Application Entity Annual_Unsecured_DTI_Preloan_Application |
If Application’s Total Income = 0 Then 0 Else (Application's Total Trades Payment Unsecured Open Preloan / Application’s Total Income) * 12 |
|
Capacity Postloan |
Applicant Entity Capacity_Postloan_Applicant |
If Applicant’s Total Trades Limit Revolving Open Postloan = 0 Then 0 Else Applicant's Total Trades Balance Revolving Open Postloan / Applicant's Total Trades Limit Revolving Open Postloan |
|
|
Application Entity Capacity_Postloan_Application |
If Application’s Total Trades Limit Revolving Open Postloan = 0 Then 0 Else Application's Total Trades Balance Revolving Open Postloan / Application's Total Trades Limit Revolving Open Postloan |
|
Capacity Preloan |
Applicant Entity Capacity_Preloan_Applicant |
If Applicant’s Total Trades Limit Revolving Open Preloan = 0 Then 0 Else Applicant's Total Trades Balance Revolving Open Preloan / Applicant's Total Trades Limit Revolving Open Preloan |
|
|
Application Entity Capacity_Preloan_Application |
If Application’s Total Trades Limit Revolving Open Preloan = 0 Then 0 Else Application's Total Trades Balance Revolving Open Preloan / Application's Total Trades Limit Revolving Open Preloan |
|
Combined Loan To Value |
Application Entity Combined_LTV_Application |
If (Total Collateral Value – total Liens) = 0 then 0 Else (If Application is Decisioned, Disbursed or is in Pending Disbursement status then Combined LTV = (FinalLoanAmount + TotalLienAmount) / TotalColateralValue Else Combined LTV = (InitialLoanAmount + TotalLienAmount) / TotalColateralValue |
|
Debt To Income Expenses Postloan |
Applicant Entity DTI_Expenses_Postloan_Applicant |
If Applicant's Total Income = 0 Then 0 Else Application Total Expenses Payment Postloan / Application Total Income |
|
|
Application Entity DTI_Expenses_Postloan_Application |
If Application's Total Income = 0 then 0 Else Application Total Expenses Payment Postloan / Application Total Income |
|
Debt to Income Expenses Preloan |
Applicant Entity DTI_Expenses_Preloan_Applicant |
If Applicant's Total Income = 0 Then 0 Else Applicant Total Expenses Payment Preloan / Applicant Total Income |
|
|
Application Entity DTI_Expenses_Preloan_Application |
If Application 'sTotal Income = 0 then 0 Else Application's Total Expenses Payment Preloan / Application's Total Income |
|
Debt To Income Trades Open Postloan |
Applicant Entity DTI_Trades_Open_Postloan_Applicant |
If Applicant's Total Income = 0 Then 0 Else Applicant's Total Trades Payment Open Postloan /Applicant's Total Income |
|
|
Application Entity DTI_Trades_Open_Postloan_Application |
If Application 'sTotal Income = 0 then 0 Else Application's Total Trades Payment Open Postloan / Application'sTotal Income |
| Debt To Income Trades Open Preloan |
Applicant Entity DTI_Trades_Open_Preloan_Applicant |
If Applicant's Total Income = 0 Then 0 Else Applicant's Total Trades Payment Open Preloan / Applicant's Total Income |
|
Application Entity DTI_Trades_Open_Preloan_Application |
If Application's Total Income = 0 then 0 Else Application's Total Trades Payment Open Preloan / Application'sTotal Income |
|
| Housing Debt To Income Postloan |
Applicant Entity Housing_DTI_Postloan_Applicant |
If Applicant's Total Income = 0 Then 0 Else Applicant's Total Expenses Payment Housing Postloan / Applicant's Total Income |
|
Application Entity Housing_DTI_Postloan_Application |
If Application 'sTotal Income = 0 then 0 Else Application's Total Expenses Payment Housing Postloan / Application's Total Income |
|
| Housing Debt To Income Preloan |
Applicant Entity Housing_DTI_Preloan_Applicant |
If Applicant's Total Income = 0 Then 0 Else Applicant's Total Expenses Payment Housing Preloan / Applicant's Total Income |
|
Application Entity Housing_DTI_Preloan_Application |
If Application 'sTotal Income = 0 then 0 Else Application's Total Expenses Payment Housing Preloan / Application's Total Income |
|
| Loan Payment to Income |
Applicant Entity Loan_Payment_To_Income_Applicant
|
If Applicant's Total Income = 0 Then 0 Else Application Payment Amount / Applicant's Total Income |
|
Application Entity Loan_Payment_To_Income_Application |
If Application's Total Income = 0 then 0 Else Application Payment Amount / Application's Total Income |
|
| Loan To Value |
Application Entity LTV_Application |
If Total Collateral Value = 0 then 0 Else (If Application is Decisioned, Disbursed or is in Pending Disbursement status then LTV = FinalLoanAmount / TotalColateralValue Else LTV = InitialLoanAmount / TotalColateralValue |
| Revolving Balance To Annual Income Postloan |
Applicant Entity Revolving_Balance_To_Annual_Income_Postloan_Applicant |
If Applicant's Total Income = 0 Then 0 Else Applicant's Total Trades Balances Revolving Open Postloan / (Applicant's Total Income * 12) |
|
Application Entity Revolving_Balance_To_Annual_Income_Postloan_Application |
If Application 'sTotal Income = 0 then 0 Else Application's Total Trades Balances Revolving Open Postloan / (Application's Total Income * 12) |
|
| Revolving Balance To Annual Income Preloan |
Applicant Entity Revolving_Balance_To_Annual_Income_Preloan_Applicant |
If Applicant's Total Income = 0 Then 0 Else Applicant's Total Trades Balances Revolving Open Preloan / (Applicant's Total Income * 12) |
|
Application Entity Revolving_Balance_To_Annual_Income_Preloan_Application |
If Application 'sTotal Income = 0 then 0 Else Application's Total Trades Balances Revolving Open Preloan / (Application's Total Income * 12) |
|
| Revolving Debt To Income Postloan |
Applicant Entity Revolving_DTI_Postloan_Applicant |
If Applicant's Total Income = 0 Then 0 Else Applicant's Total Trades Payment Revolving Open Postloan / Applicant's Total Income |
|
Application Entity Revolving_DTI_Postloan_Application |
If Application 'sTotal Income = 0 then 0 Else Application's Total Trades Payment Revolving Open Postloan / Application's Total Income |
|
| Revolving Debt To Income Preloan |
Applicant Entity Revolving_DTI_Preloan_Applicant |
If Applicant's Total Income = 0 Then 0 Else Applicant's Total Trades Payment Revolving Open Preloan / Applicant's Total Income |
|
Application Entity Revolving_DTI_Preloan_Application |
If Application 'sTotal Income = 0 then 0 Else Application's Total Trades Payment Revolving Open Preloan / Application's Total Income |
|
| Revolving Limit To Annual Income Postloan |
Applicant Entity Revolving_Limit_To_Annual_Income_Postloan_Applicant |
If Applicant's Total Income = 0 Then 0 Else Applicant's Total Trades Limit Revolving Open Postloan / (Applicant's Total Income *12) |
|
Application Entity Revolving_Limit_To_Annual_Income_Postloan_Application |
If Applicant's Total Income = 0 Then 0 Else Application's Total Trades Limit Revolving Open Postloan / (Application's Total Income *12) |
|
| Revolving Limit To Annual Income Preloan |
Applicant Entity Revolving_Limit_To_Annual_Income_Preloan_Applicant |
If Applicant's Total Income = 0 Then 0 Else Applicant's Total Trades Limit Revolving Open Preloan / (Applicant's Total Income *12) |
|
Application Entity Revolving_Limit_To_Annual_Income_Preloan_Application |
If Applicant's Total Income = 0 Then 0 Else Application's Total Trades Limit Revolving Open Preloan / (Application's Total Income *12) |
|
| Unsecured Balance To Annual Income Postloan |
Applicant Entity Unsecured_Balance_To_Annual_Income_Postloan_Applicant |
If Applicant's Total Income = 0 Then 0 Else Applicant's Total Expenses Balance Unsecured Postloan / (Applicant's Total Income *12) |
|
Application Entity Unsecured_Balance_To_Annual_Income_Postloan_Application |
If Applicant's Total Income = 0 Then 0 Else Application's Total Expenses Balance Unsecured Postloan / (Application's Total Income *12) |
|
| Unsecured Balance To Annual Income Preloan |
Applicant Entity Unsecured_Balance_To_Annual_Income_Preloan_Applicant |
If Applicant's Total Income = 0 Then 0 Else Applicant's Total Expenses Balance Unsecured Preloan / (Applicant's Total Income *12) |
|
Application Entity Unsecured_Balance_To_Annual_Income_Preloan_Application |
If Applicant's Total Income = 0 Then 0 Else Application's Total Expenses Balance Unsecured Preloan / (Application's Total Income *12) |
|
| Unsecured Balance To Annual Income FI Postloan |
Applicant Entity Unsecured_Balance_To_Annual_Income_FI_Postloan_Applicant |
If Applicant's Total Income = 0 Then 0 Else Applicant's Total Expenses Balance Unsecured FI Postloan / (Applicant's Total Income *12) |
|
Application Entity Unsecured_Balance_To_Annual_Income_FI_Postloan_Application |
If Applicant's Total Income = 0 Then 0 Else Application's Total Expenses Balance Unsecured FI Postloan / (Application's Total Income *12) |
|
| Unsecured Balance To Annual Income FI Preloan |
Applicant Entity Unsecured_Balance_To_Annual_Income_FI_Preloan_Applicant |
If Applicant's Total Income = 0 Then 0 Else Applicant's Total Expenses Balance Unsecured FI Preloan / (Applicant's Total Income *12) |
|
Application Entity Unsecured_Balance_To_Annual_Income_FI_Preloan_Application |
If Applicant's Total Income = 0 Then 0 Else Application's Total Expenses Balance Unsecured FI Preloan / (Application's Total Income *12) |
|
| Unsecured Debt To Income Postloan |
Applicant Entity Unsecured_DTI_Postloan_Applicant |
If Applicant's Total Income = 0 Then 0 Else Applicant's Total Trades Payment Unsecured Open Postloan / (Applicant's Total Income *12) |
|
Application Entity Unsecured_DTI_Postloan_Application |
If Applicant's Total Income = 0 Then 0 Else Application's Total Trades Payment Unsecured Open Postloan / (Application's Total Income *12) |
|
| Unsecured Debt To Income Preloan |
Applicant Entity Unsecured_DTI_Preloan_Applicant |
If Applicant's Total Income = 0 Then 0 Else Applicant's Total Trades Payment Unsecured Open Preloan / (Applicant's Total Income *12) |
|
Application Entity Unsecured_DTI_Preloan_Application |
If Applicant's Total Income = 0 Then 0 Else Application's Total Trades Payment Unsecured Open Preloan / (Application's Total Income *12) |
|
Ratios are assigned at the sub-product level within the Table Entries tab in Loan Application Types and/or Account Application Types. |
The following system-defined rules are available within the Validation Rules category:
| Rule | Description |
| Min_Opening_Balance_Validation | If the total of Amount in Fundings is less than MinimumOpeningBalance, then display a warning message of "The Funding Amount is less that the Minimum Opening Balance for this Account Product." |
| ToDo_Pitch_CrossSells | If number of CrossSells where IsPitched field is False is greater than 0, then adds a To-Do that is required for disbursement stating, "You have X# cross-sell opportunities remaining to be pitched before you can disburse." |
| Rule | Description |
| FISBASE2000VariablePaymentDateTypeValidation | If DisbursementProvider = FISBase200 and VariablePaymentDateType = Number of Days Prior to Due Date, then displays an error message of "Number of Days Prior to Due Date is not supported by FIS BASE2000." |
| UDAPRequiredForFISBASE2000 | If DisbursementProvider = FIS Base2000 and UDAPOverdraftFeeOption = 0, then displays an error message stating, "UDAP Overdraft Fee Option is required for FIS BASE2000." |
| Rule | Description |
| HMDA_ApplicationField_Validation |
Validates that fields required for HMDA Reporting do not contain blank values, based on the Action Date set for the HMDA connector. This rule reviews the HMDA ActionDate to determine which fields are required for the applicable year, and then validates that a value has been entered for each of those fields in the application. If any of the required fields are left blank, this rule displays an error message to identify that the HMDA information must be completed. |
| HMDA_Race_Ethnicity_Validation |
Validates that race or ethnicity sub-categories are not selected in a HMDA application when the Applicant Ethnicity Collection or Applicant Race Collection field is set to a value of "Collected on basis of visual observation or surname." If Applicant Ethnicity Collection or Applicant Race Collection is set to a value of "Collected on basis of visual observation or surname," this rule displays a warning message to alert the user that the Applicant Ethnicity or Applicant Race sub-categories must be de-selected in the application. |
